Tuning / Tweaking MySQL

Posted by: Chris  :  Category: Linux Tips

There are a couple of good scripts out there that will help you to tune your mysql usage for better perfomance.  I’ve used both of these, and they are very intuative.  Personally, I prefer the latter, however, I still use both for tweaking.


“This script takes information from “SHOW STATUS LIKE…” and “SHOW VARIABLES LIKE…”
to produce sane recomendations for tuning server variables.”


root@server [~/downloads] # wget http://day32.com/MySQL/tuning-primer.sh

root@server [~/downloads] # chmod 755 tuning-primer.sh

To run the script:

root@server [~downloads]#./tuning-primer.sh


“mysqlreport makes a friendly report of important MySQL status values. mysqlreport transforms the values from SHOW STATUS into an easy-to-read report that provides an in-depth understanding of how well MySQL is running. mysqlreport is a better alternative (and practically the only alternative) to manually interpreting SHOW STATUS.”


root@server [~downloads]# wget hackmysql.com/scripts/mysqlreport

root@server [~downloads]#chmod 755 mysqlreport

To run the script:

root@server [~downloads]#./mysqlreport
This is the guide to help in understanding all of the information that will be thrown your way :



4 Responses to “Tuning / Tweaking MySQL”

  1. ex23ander Says:

    I want to quote your post in my blog. It can?
    And you et an account on Twitter?

  2. Chris Says:

    Yes, you may quote this post, but please, make sure you reference me as the original author.

  3. Server Optimization? - cPanel Forums Says:

    […] […]

  4. Very high system loads Says:

    […] a blog post I did a while back, it explains a couple of tools to use to tweak MySQL perfomance: SolidServers.ca Blog Archive Tuning / Tweaking MySQL Reply With Quote […]

Leave a Reply