Tens of hundreds of thousands of hours are wasted every day world-wide (rough estimates) doing something that’s dead simple if only one understands few basic principles of MySQL operation.
Yes, MySQL configuration. I am looking at you!
All this time will never be given back, but if there’s anything I could do to save the world from more waste testing different MySQL configuration settings by the means of trial-and-error, this is it.
I don’t know how you got here, but I’m guessing it wasn’t by chance, so you should already know enough about me to trust me on this. Long story short, I’ve been optimizing MySQL for best performance with great success since 2004, and I’ve spent last 9 years at Percona – leading independent MySQL consutlancy company.
Anyways, few weeks ago I have written a wildly popular blog post called “17 Key MySQL Config File Settings” and then I decided to take a step further. I decided to prepared a my.cnf file with all of the recommendations, short useful descriptions and also links to more information on each variable to catch up on it easily.
You can download this file here and use it on your server with few or no changes. Just enter your email below to download the file.
You are welcome!
Download The Perfect my.cnf
I created a special my.cnf with a recommended configuration (and useful comments to help you fine-tune it). You can download it here.
You will also get a free MySQL Configuration Tuning Handbook with these 17 variables discussed in-depth, as well as an introduction to MySQL status monitoring.