Using MySQLTuner to Optimize MySQL configuration

Janeiro 30th, 2018

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)

Download/Installation

• wget http://mysqltuner.pl/ -O mysqltuner.pl

Using…

• perl mysqltuner.pl

Open the file my.cnf and change the values that Mysqltuner advise

• vi /etc/mysql/my.cnf

or

• vi /etc/my.cnf