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 for the complete command, it's a real help for searching the log but I don't think it's such a good idea to monitor this way. If the limit time will be short I think there will be alot of activity writing the queries to the log .. and the size of the log will increase quickly.
Any other suggestions ?
How are you all Server Admins searching for high activity websites on your server ? (not constant but spikes of high activity)
I just found some plugin for munin but it seems it's not working on apache 2 as it relies on mod_watch
I have attached the graph too, it will be nice to have something like this for mysql ... I'm doing some searchiung about this plugin because if it will work this can show me the websites with lots of traffic. Anyone had any problem with mod_watch for apache on cPanel server ? (One server has Apache/1.3.39 and the other one has Apache/2.2.9)