What is MySQLTuner
MySQLTuner is a great little utility to tune up your MySQL instance to perform at it best.
yum -y install https://extras.getpagespeed.com/release-el7-latest.rpm yum -y install mysqltuner
mysqltuner and get overwhelmed with a list of tweak suggestions.
Our MySQLTuner package ships with
vulnerabilities.csv, so when you run
mysqltuner, it will report you whether your MySQL has any vulnerabilities or poor user passwords.
You can get weekly suggestions (if any) for MySQLTuner by using
yum -y install mysqltuner-cron
mysqltuner will be run every week and only if there are suggestions, they will be emailed to you by cron.
To reduce the memory footprint of MySQL, you can run
mysqlmemory that is shipped with the package. More info about it here.