How to monitor MySQL loading?

I'm maintain a server with shared hosting. It has hundreds of websites. Time to time, users complain that their sites (especially with dinamical-generated content) are loading slowly. I've found out that it happens cause of high loading of MySQL server by some websites.

Is there way to monitor MySQL server continiously in order to check which website performs large number of requests?

 

 

 

 

Top