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.”
Installation:
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.”
Installation:
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 :
http://hackmysql.com/mysqlreportguide
I want to quote your post in my blog. It can?
And you et an account on Twitter?
Yes, you may quote this post, but please, make sure you reference me as the original author.