I need to know if these settings are appropriate for a high sql usage environment running multiple forums. Please let me know if there are any areas you would recommend changing or tweaking. My load averages are typically 1-4%, however some sites are spiking 40% cpu usage. It would help to know if there are any cache'ing tricks I can use, or other methods which will help in using more memory and less cpu in the environment(s) I am speaking of. Any assistance is much appreciated. Obviously I'm using the latest LSWS.
My server details are:
Centos 5.3 (32 bit)
Dual Xeon Quad Cores 2.66ghz
10mbps with up to 100mbps burst
You have a server with 4GB RAM in total, and yet you tell MySQL to allocate:
- 4GB for the key_buffer
- 2GB for the query cache
- 1GB for myisam_sort_buffer_size
+ setting aside huge amounts of RAM for other variables
+ setting hugely long wait and connect timeouts
+ setting hugely high max connections...
Enjoy your server choking up from too many open connections held open for too long, and from swapping itself extensively to disk.
Those settings apply to myisam tables, but who uses myisam these days? Innodb has evolved enough that the performance differences are negligable unless you have 1000+ shared users on same db, innodb supports transactions too.
And yes agreed with brr, WTF kind of configuration is that @Elfz LOL.
Hopefully no one actually tried it.