Is there an easy method for doing MySQL tuning?

Question

You may be experiencing issues with MySQL using more resources than expected or acting inconsistently. While cPanel would recommend reaching out to a qualified MySQL system administrator for assistance with major issues, you may want to see if tweaking some MySQL settings will alleviate your issue.

So, is there an easy method for doing MySQL tuning?

Answer

On GitHub, there is a script available that can view your MySQL settings and make suggestions on your behalf.

** Please be aware. This script is not supported or created by cPanel and is mentioned as a reference. **

The script location is here.

MySQLTuner-perl

Please reference the following article for instruction on modifying your MySQL Settings.

How to edit the MySQL/MariaDB configuration (my.cnf) file