Jet Profiler for MySQL is a really good tool to diagnostic MySQL database for tables, user performance, query, using graphical visualisation, and it’s user friendly.
Main features such as ” Top Queries, Top Users, Top Tables, Top States, Replication Profiling, Master and Slave statistics, MyISAM Lock Analysis, Query Ratings, Query Visualization, Slow Queries, Zoomable GUI, General Server Metrics, Save / Load Support, Low Overhead, Supports all MySQL Versions, …”
check this one minute video for how t o use Jet Profiler for MySQL database. Here
More information and Download Options Here