MySQLTuner
From MySQLTuner
Welcome to the new MySQLTuner Wiki. This wiki contains documentation, download links, change logs, and general MySQL configuration recommendations. For the impatient, you can download MySQLTuner in plain text or gzipped forms.
The latest stable version of MySQLTuner is 1.0.0 and it was released on December 1st.
For more information about MySQLTuner or other technology-related content, please visit RackerHacker.
Contents |
What can MySQLTuner do?
MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved.
It's key to remember that MySQLTuner is a script which can assist you with your server, but it is not the solution to a badly performing MySQL server. The best performance gains come from a thorough review of the queries sent to the server, and an evaluation of the MySQL server itself. A qualified developer in your application's programming or scripting language should be able to work with a MySQL database administrator to find improvements for your server. Once the server and application are optimized well, you may need to consider hardware upgrades to the physical server itself.
System Requirements
The system requirements of MySQLTuner are very low in order to improve compatibility with as many systems as possible. To run the script, you will need the following:
- Perl 5.6 or later
- MySQL 3.23 or later
- (fully supported: 3.23, 4.0, 4.1, 5.0, 5.1; partially supported: 6.0)
- A Unix/Linux based operating system
- (tested on Linux, BSD variants, and Solaris)
- Unrestricted read access to the MySQL server
- (OS root access is recommended for MySQL versions before 5.0)
How to get and use MySQLTuner
MySQLTuner is available via different methods:
Quick Start
wget mysqltuner.pl chmod 0700 mysqltuner.pl ./mysqltuner.pl
Downloading MySQLTuner
Download the latest version in plain text to your server with wget:
# wget mysqltuner.pl
Or, you can download the gzipped version:
# wget mysqltuner.pl/mysqltuner.pl.gz
To run the script, simply make it executable and run it:
# chmod +x mysqltuner.pl # ./mysqltuner.pl
Downloading directly from the mysqltuner.pl domain name will redirect to the plain text version of the script. You can review the previous versions and choose one to download.
Checking out the latest subversion version
# svn co http://tools.assembla.com/svn/mysqltuner/ .
As with most software projects, downloading from subversion may provide you with a script that has not been thoroughly tested. It's recommended to download the current release or a previous release version.
Reviewing the changelog
All changes between versions are documented in the changelog.
Mailing List
There is a very low-traffic mailing list for MySQLTuner announcements. E-mails are sent to the list when a new beta or final release are available for download. To subscribe, send an e-mail with SUBSCRIBE in the subject line to mysqltuner-announce-request@mysqltuner.com. Once you confirm your subscription, you will receive updates until you choose to unsubscribe.
This is the fastest way to find out when a new version of MySQLTuner is available.
Development
MySQLTuner is currently in active development, and your bug and feature requests are welcomed. To submit a request, simply e-mail major [at] mhtx [dot] net. When you send the e-mail, be sure to provide me with the following:
- As much output from the script (including errors) that you can provide
- Your operating system and version
- Your MySQL version
- Where you obtained the MySQL version (compiled from source, from mysql, from your OS vendor, etc)
Contributors
I'd like to thank the following people for their assistance with this project. Without their help, this project would not be possible:
- Matthew Montgomery, Paul Kehrer, Dave Burgess, Jonathan Hinds, Mike Jackson, Nils Breunese, Shawn Ashlee, Luuk Vosslamber, Ville Skytta, Trent Hornibrook, Jason Gill, Mark Imbriaco, Greg Eden, Aubin Galinotti, Giovanni Bechis, and Bill Bradford.
Support MySQLTuner!
The primary developer and maintainer for MySQLTuner is Major Hayden. I work on MySQLTuner in my spare time as an open source project to contribute back to the world which has taught me so much. If you enjoy using MySQLTuner, and you want to send a donation to cover the expenses of the server or my time, you're welcome to do so! You can use PayPal to send money to major [at] mhtx [dot] net and I will be eternally grateful for your support.
