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

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.

tuning-primer

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

Installation:

[email protected] [~/downloads] # wget http://day32.com/MySQL/tuning-primer.sh

[email protected] [~/downloads] # chmod 755 tuning-primer.sh

To run the script:

[email protected] [~downloads]#./tuning-primer.sh


mysqlreport

“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.”

Installation:

[email protected] [~downloads]# wget hackmysql.com/scripts/mysqlreport

[email protected] [~downloads]#chmod 755 mysqlreport

To run the script:

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

http://hackmysql.com/mysqlreportguide

mysqlreport

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: SolidServers.ca Blog Archive Tuning / Tweaking MySQL Reply With Quote […]

Leave a Reply

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