I noticed that every time I log into the site the resource from scratch goes to 859.89MB / 2GB (41.99%).
How can this load be reduced?
Where copy this code
key_buffer_size = 448M
sort_buffer_size = 64M
Do you have a guide?
Hi Tobix,
The MySQL configuration is normally /etc/mysql/my.cnf - to edit it you would need to have root access to the server; and I would suggest making sure you have a backup first. If you don't have root access you would probably need to ask your hosting to support to make the changes for you.
When editing the file, first search for any existing setting for each and change it if already specified, otherwise if they are not present then add them as new lines at the end.
Cheers,
David.
--
PriceTapestry.com
Hi Tobix,
Have you optimised your MySQL configuration for a large database; if not have a read through this thread, it is suggest to allocate up to 1/4 of total physical server memory to the buffer sizes, in particular key_buffer_size so if you have 2GB of RAM for example
key_buffer_size = 448M
sort_buffer_size = 64M
Don't forget to restart MySQL after making configuration changes to ensure that they are applied...
Cheers,
David.
--
PriceTapestry.com