MySQL Tuner is a versatile script that gives recommendations on improving database related measures from over 300 indicators. You can run the script on your server and based on the recommendations you can resolve some of the issues (if not all) that you might be facing with regards to database.
Improve MySQL Performance using these hacks
1. Allot more RAM to innodb_buffer_pool_size variable in /etc/my.cnf file depending on the amount of RAM available on the Server set the value as below:
“innodb_buffer_pool_size=8G”
2. Enable Performance Schema from /etc/my.cnf
“performance_schema=ON”
3. Add skip-name-resolve variable in /etc/my.cnf in the last row like this:
“skip-name-resolve=0”