Informational Website publish


News about our company, tutorials about IT and much more you will find in this page.

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.


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


  • wget -O


  • perl

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

  • vi /etc/mysql/my.cnf


  • vi /etc/my.cnf