Overview

Tuning MySQL depends on many variables, such as server resources, database sizes, and number of connections. The following tool can be helpful for providing suggestions.  

 https://github.com/pmachapman/mysqltuner