How to config mysql-server for heavy load
- by Rasmus
Im in the process of setting up a new database server. I have been running a few mysql database servers before and it has been working okay.
But i would like to hear the recommended setup for my server. For example, what should i set the max connection, query_cache_size, table_cache and so on.
I have arround 4-600 per second:
Open tables: 112 Queries per second avg: 430.386.
The server i am setting it up on have the following configuration:
Linux version 2.6.32-5-amd64 (Debian 2.6.32-41squeeze2)
2x Intel Xeon X3440 @ 2.53GHz
4GB Ram
/, /boot, /tmp etc on Software RAID1, 2x 7200RPM SATA
Data location on Software RAID0, 2x7200RPM SATA
Im am going to place the mysql databases on the RAID0.
Am im missing anything? Let me know!
Thanks in advance, im looking forward to hearing from you :-)
/Rasmus