News about our company, tutorials about IT and much more you will find in this page.
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)
Open the file my.cnf and change the values that Mysqltuner advise