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