MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief format along with some basic performance suggestions.
- MySQL 3.23, 4.0, 4.1, 5.0, 5.1, 5.5, 5.6 (full support)
- MariaDB 10.1, 11.0 (full support)
- Perl 5.6 or later (with perl-doc package)
- Unix/Linux based operating system (tested on Linux, BSD variants, and Solaris variants)
- Windows is not supported at this time
- Unrestricted read access to the MySQL server (OS root access recommended for MySQL < 5.0)
It is extremely important for you to fully understand each change you make to a MySQL database server. If you don’t understand portions of the script’s output, or if you don’t understand the recommendations, you should consult a knowledgeable DBA or system administrator that you trust. Always test your changes on staging environments, and always keep in mind that improvements in one area cannegatively affect MySQL in other areas.
Seriously – please review the FAQ section below.
Checks performed by MySQLTuner
All checks done by MySQLTuner are documented in MySQLTuner Internalsdocumentation.
You can download the entire repository by using ‘git clone’ followed by the cloning URL above. The simplest and shortest method is:
wget http://mysqltuner.pl/ -O mysqltuner.pl wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/basic_passwords.txt -O basic_passwords.txt perl mysqltuner.pl
Of course, you can add the execute bit (
chmod +x mysqltuner.pl) so you can execute it without calling perl directly.