can you pinpoint which mysql database is using most cpu?

We're having load spikes again, it was up to 13 the other day, and has been spiking to 7 or 8 every now and then since.

I have 4 main databases running on the site. A vB forum, a pMachine Pro blog, an Incursio reviews script, and a recipe database. All are very busy, and all on one account.

We're on a dedicated server running MySql 4.0.14

I've been told by tech that our load problems are due to mysql.

I'd really like to know which database is causing the problem, if it can be blamed on just one.

Is there a command that will show how each database utilizes resources?

 

 

 

 

Top