MySQL Forums
Forum List  »  PHP

Re: Query is periodically order of magnitude slower after upgrading from MySQL 5.0 to Percona 5.5
Posted by: Rick James
Date: June 06, 2015 12:10PM

Was the table ENGINE=InnoDB in both versions?

Was the Query Cache turned off in both cases?

Please provide (from both versions):
EXPLAIN EXTENDED SELECT ... ;
SHOW WARNINGS;

Options: ReplyQuote


Subject
Written By
Posted
Re: Query is periodically order of magnitude slower after upgrading from MySQL 5.0 to Percona 5.5
June 06, 2015 12:10PM


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.