Re: Database tuning

[Joao Prado Maia]

Hi,

The 99% of CPU usage is not normal with MySQL. My best suggestion would be for you to review your queries and make sure that you don't have any cartesian product of all tables that you are trying to access (i.e. you are missing a join condition somewhere).

The following URL might be useful as well. The EXPLAIN command will allow you to review your queries and make sure that everything is running like you want:

http://dev.mysql.com/doc/mysql/en/EXPLAIN.html

Hope that helps.

Cheers,
Joao Prado Maia
MySQL AB