MySQL Forums
Forum List  »  Newbie

Re: Database tuning
Posted by: Joao Prado Maia
Date: September 01, 2004 09:26AM


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:

Hope that helps.

Joao Prado Maia

Options: ReplyQuote

Written By
August 31, 2004 08:37PM
Re: Database tuning
September 01, 2004 09:26AM
September 01, 2004 08:40PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.