MySQL Forums
Forum List  »  Performance

Re: Performance issues - 99% CPU
Posted by: James Day
Date: January 18, 2005 11:50PM

OPTIMIZE TABLE tablename;

Do that on the one table and see if the problem goes away. If you haven't done it in a while, doing it on all tables may well be useful. Expect your site to be unavailable while it is running.

Options: ReplyQuote


Subject
Views
Written By
Posted
2639
January 17, 2005 08:06PM
1784
January 18, 2005 12:33AM
1610
January 18, 2005 09:51PM
Re: Performance issues - 99% CPU
1731
January 18, 2005 11:50PM


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.