Tune MySQL using MySQLTuner
Every once in a while you see your MySQL showing increased memory footprint.
You want to optimize MySQL but you do not know where to start from as first you need to know what all you should be tuning.
This where MySQLTuner script can help you. As it’s README says:
“_MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief format along with some basic performance suggestions._”