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?

IMHO that won't be possible based on database, but I think you can put a limit on the "user" and watch users.

Try "SHOW PROCESSLIST" on mysql. And also check the max_user_connections on configuration file.

Hope this helps :)