MySQL / Server Setup

Install MySQLTuner in CentOS/RHEL

by , , revisited on

We have by far the largest RPM repository with dynamic stable NGINX modules and VMODs for Varnish 4.1 and 6.0 LTS. If you want to install NGINX, Varnish, and lots of useful modules for them, this is your one-stop repository to get all performance-related software.
You have to maintain an active subscription in order to be able to use the repository!

What is MySQLTuner

MySQLTuner is a great little utility to tune up your MySQL instance to perform at it best.

Install MySQLTuner

yum -y install
yum -y install mysqltuner

Run MySQLTuner

Simply type mysqltuner and get overwhelmed with a list of tweak suggestions.

Our MySQLTuner package ships with basic_passwords.txt and vulnerabilities.csv, so when you run mysqltuner, it will report you whether your MySQL has any vulnerabilities or poor user passwords.

Schedule reports

You can get weekly suggestions (if any) for MySQLTuner by using mysqltuner-cron package:

yum -y install mysqltuner-cron

Then mysqltuner will be run every week and only if there are suggestions, they will be emailed to you by cron.

Small bonus, mysqlmemory

To reduce the memory footprint of MySQL, you can run mysqlmemory that is shipped with the package. More info about it here.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: