MySQL Tuner

Posted on

Just a small note about amazing tool, that can analyze runtime variables of your MySQL server (also MariaDB) and give overview and recommendations – based on server usage.

A good place to start is to run MySQLTuner. This script automatically assesses your MySQL server against 300 possible performance indicators. It’ll produce a list of suggestions that could help you get more from your environment.

MySQLTuner is distributed as a Perl script, so you’ll need Perl installed on your system. Use the following commands to download and run MySQLTuner:

wget http://mysqltuner.pl/ -O mysqltuner.pl
chmod +x mysqltuner.pl
./mysqltuner.pl --host 127.0.0.1 --username root --pass mysql-password

Source: https://www.cloudsavvyit.com/10275/how-to-analyse-mysql-performance-problems/

 

 

 

Linux, MySQL, Security , ,