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.
Subject
Views
Written By
Posted
2486
March 24, 2005 09:19AM
Re: MySQL Perfomace with two DB must be so slow?
1716
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.