As you probably gather I do quite a bit of MySQL work, in fact over the years I’ve sort of become the MySQL DBA where I work. From time to time we’ve had issues where our MySQL server just aren’t performing as well as they could. Sure we could hire an expensive consultant, but I’ve come across this tool called MySQLTuner which gives me the ability to see what settings I should tune.
It’s a simple perl script and to use it is really easy. First, download the script to your linux server, change it to be executable, then run it
wget http://mysqltuner.com/mysqltuner.pl
chmod 0700 mysqltuner.pl
./mysqltuner.pl
You’ll get a great one page output which gives you some great detail about what’s going on, and what settings can be used in your my.cnf file. One word of caution, make sure you backup your my.cnf before making changes, and you should also spend some time learning what the values mean.
February 18th, 2009 at 6:42 pm
Thanks Matt! I had a question about sed and came here to find my answer, and then found this tool, which has verified what we thought was our problem with the SCST site. This blog is a great resource, keep it up!