Informational Website publish

Blog

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.

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