Limiting MySQL CPU usage and monitoring

All the MySQL gurus, hopefully you can help me answer this one:

My server is bogged down by mysql but I don't know which databases are the main CPU hoggers. Is there a way for me to see which database is taking up the most CPU cycles?

Also, is there a way to limit CPU usage per mysql database?

 

 

 

 

Top