Following up my previous post regarding server performance, I wanted to try and communicate my experiences with tuning specific applications that might run alongside (and under) Apache. MySQL has become amazingly popular during the last couple of years and its popularity is not undeserved. It performs well already out of the box and the fifth version is incredibly stable.

There are (of course! :D) a number of things you can do to improve your mySQL performance however, and here they are, in all their glory! :p

MySQL tuning:

Figured I might as well start with the pedal to the metal with this whole concept. This is part one of what will (hopefully) be a comprehensive guide to how to maximize performance on your Apache based web server. Not just httpd though, but also general server memory optimization as well as tips and tricks to make mySQL run as smooth as possible. Enjoy!

Apache tuning: