MySQL Forums
Forum List  »  Performance

Re: MySQL Perfomace with two DB must be so slow?
Posted by: James Day
Date: March 27, 2005 08:36PM

High CPU may indicate many table and index scans. Try running ANALYZE TABLE tablename for each table. It may be because of out of date query optimizer statistics and the analyze will update them.

Use is probably in each log entry to ensure that the default database is always correct, even when updates from many different connections, with different current database, are mixed.

Are you using my_huge.cnf? Any my.cnf file at all? If none, pick the right one for your RAM and use and tune starting from there.

Options: ReplyQuote

Written By
Re: MySQL Perfomace with two DB must be so slow?
March 27, 2005 08:36PM

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.