Readers of PlanetMySQL may have recently noticed some posts on tuning MySQL server performance in five minutes or even in three minutes, I’d like to take things in the opposite direction, showing you how to tune performance in two to four days.
Actually I should say you can learn to tune performance in two to four days, tuning itself actually takes a long time and is a continuing process because things change constantly. I’m not talking about performance tuning in the ‘limit resource usage so the server does not crash’ sense that you see in limiting connections, but in the sense of getting the most from your server, making specific changes and measuring the results. Remember folks, if you don’t benchmark you have no idea if your changes have improved your situation or actually made it worse. Do you want to know if your server can handle a traffic spike? Better to simulate one ahead of time than find out the hard way.
So …[Read more]