MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, and Percona Toolkit

Running MySQL databases require regular health checks to ensure performance, proper configuration, and security.

This article introduces several popular MySQL optimization tools: mysqltuner.pl, tuning-primer.sh, and Percona Toolkit's pt-variable-advisor and pt-query-digest.

mysqltuner.pl is a widely used diagnostic script that evaluates parameter settings, logs, storage engines, and provides recommendations. Download and run it with:

wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl

./mysqltuner.pl --socket /var/lib/mysql/mysql.sock

The tool outputs warnings such as “[!!] Maximum possible memory usage” and a list of recommendations.

tuning-primer.sh performs a comprehensive MySQL health check and suggests optimizations. Download and execute:

wget https://launchpad.net/mysql-tuning-primer/trunk/1.6-r1/+download/tuning-primer.sh

# ./tuning-primer.sh

Review the red‑flagged items and follow the advice.

Percona Toolkit includes pt-variable-advisor for checking variable settings and pt-query-digest for analyzing slow‑query logs. Install the toolkit:

wget https://www.percona.com/downloads/percona-toolkit/3.0.13/binary/redhat/7/x86_64/percona-toolkit-3.0.13-re85ce15-el7-x86_64-bundle.tar

yum install percona-toolkit-3.0.13-1.el7.x86_64.rpm

Run the advisors:

pt-variable-advisor localhost --socket /var/lib/mysql/mysql.sock

pt-query-digest /var/lib/mysql/slowtest-slow.log

Various usage examples show how to filter queries by time range, type, or user, and how to generate detailed reports.

By employing these tools, administrators can obtain overall statistics, query‑group rankings, and detailed per‑query metrics, enabling informed optimization decisions for MySQL performance.