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: 358

Filed under:
|
|
|

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

Related posts about linux

Related posts about mysql