MySQLTuner-perl

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.

Compatibility:

• 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)

WARNING

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.

Download/Installation

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.