Re: Mysql : Completely strange performance behavior
Hi Dominique,
If I understand correctly, the problem turned out to be a different execution plan (use of different index), not replication? If replication is still a problem you will probably get a good answer in the "Replication" subforum.
Regarding 5.5 picking a worse plan: Right after you have imported a huge amount of data on a server, things like cold caches may result in poor performance. This should improve fairly quickly just by throwing the normal queries at the server.
In addition, index statistics may be completely wrong after a huge import. This can be fixed by running ANALYZE TABLE.
If ANALYZE TABLE does not help and you want to keep the index that performed bad for this query, we'll need the following info to provide more assistance:
* SHOW CREATE TABLE for all involved tables
* EXPLAIN for the query in question (both good and bad performing plans would be nice)
Subject
Views
Written By
Posted
1756
February 28, 2013 10:35AM
927
February 28, 2013 03:27PM
Re: Mysql : Completely strange performance behavior
881
March 01, 2013 07:13AM
910
March 01, 2013 08:03AM
762
March 01, 2013 08:28AM
984
March 01, 2013 08:41PM
916
March 04, 2013 02:00AM
869
March 04, 2013 11:55PM
892
March 04, 2013 03:27AM
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.