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.
Please reference the following article for instruction on modifying your MySQL Settings.