How to config mysql-server for heavy load
Posted
by
Rasmus
on Server Fault
See other posts from Server Fault
or by Rasmus
Published on 2012-04-07T14:49:19Z
Indexed on
2012/04/07
17:34 UTC
Read the original article
Hit count: 353
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
© Server Fault or respective owner