MySQL - The Perfect Server - MySQL

[fatbear]

Hi all,

I'm new to the developer group and I'm starting to install ISPConfig this weekend. One of the first things I want is to ensure that the MySQL is tuned appropriately. Please find attached the my.cnf file (inside my.zip) that I've used for some time. Note that I specify innodb as the default storage engine.

I'm looking for a critical analysis of this my.cnf file. What would you change to make this appropriate for a "The Perfect Server - MySQL" article that I'm considering to write?

I hope you enjoy looking at the my.cnf file!

[till]

The optimal mysql settings depend on the hardware of the server and the actual load. It can e.g. be better to disable innodb instead of making it the default if your server has very low ram like 1GB in a vserver as the setup has mostly reads in the db and transactions are not used. To write a perfect mysql setup guide, it might be good to define server classes like 2, 4, 8 and 16GB RAM and make individual settings for them.

My recommendation is to use mysqltuner to find the optimal settings for a specific system:

http://www.faqforge.com/linux/optimi...th-mysqltuner/