Extended monitoring for MySQL ?

Hello guys, I have 2 dedicated servers (Centos with WHM/cPanel), for the oldest server it will be great for me to have some option to monitor which users/databases are more used, I'm more interested about the "spikes" i see in the munin graphs once in a while.

This server has an average of 42 queries/second but sometimes there are some spikes of over 250 queries/second and in munin I can't see which users/databases ware causing the spike.

Curently I use munin for monitoring the server, and it's graphs are ok but I need a more detailed graphs or statistics for mysql, I searched munin plugins but there's no plugins to show the user or database which gets the most queries.

Any other idea how can I see which user/database had more queries ?

I attached a graph generated by munin, you can see the spike, I seen the spike after about one hour, when the traffic was normal, and the page in WHM - Mysql Processes couldn't help me because there's no history.

Thank you.

 

 

 

 

Top