MySQL Tuner

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 -O
chmod +x
./ --host --username root --pass mysql-password