1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 3.67 out of 5)

Tuning / Tweaking MySQL

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

root@server [~/downloads] # chmod 755

To run the script:

root@server [~downloads]#./


“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

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. […] a blog post I did a while back, it explains a couple of tools to use to tweak MySQL perfomance: Blog Archive Tuning / Tweaking MySQL Reply With Quote […]

Leave a Reply

Your email address will not be published. Required fields are marked *