I'm trying to optimise mysql (the most resource intensive component on my VPS).
How can I change "sort_buffer_size"?
Are there any other buffers that should be increased first (I have some spare RAM)?
Does these changes take effect only after the VPS is rebooted?
What size of buffers should I set (my VPS has 512 RAM and uses 30% of it at the moment)?
How can I change "sort_buffer_size"?
Are there any other buffers that should be increased first (I have some spare RAM)?
Does these changes take effect only after the VPS is rebooted?
What size of buffers should I set (my VPS has 512 RAM and uses 30% of it at the moment)?