Unless you are a total linux-freak-guru like myself, and even if you are, it can be enormously challenging and somewhat overwhelming to locate and eliminate MySQL bottlenecks. While many DBAs focus on improving the performance of the queries themselves, this post will focus on the highest-impact items: MySQL Server Performance and OS Performance for MySQL. Specifically showing 4 awesome tools to auto-tune your MySQL and a few more tools just for monitoring!

Before

init-connect='SET NAMES utf8'
init_connect='SET CHARACTER SET=utf-8'

After

init_connect='SET collation_connection = utf8_general_ci,NAMES utf8'