MySQL Forums
Forum List  »  Performance

Re: MySQL 5.6 update doubled IOs
Posted by: Olav Sandstå
Date: April 02, 2013 12:20AM

The explain for the 5.6 version of the query says that it will be "Using MRR". This might not be good for "LIMIT 1" query. Can you try to run the query when support for MRR is disabled, eg. by adding:

set optimizer_switch='mrr=off';

to see if this has any impact on the performance.

Best regards,
Olav

Options: ReplyQuote


Subject
Views
Written By
Posted
1255
March 20, 2013 08:52AM
1161
March 27, 2013 11:44PM
1192
March 28, 2013 07:49PM
Re: MySQL 5.6 update doubled IOs
1115
April 02, 2013 12:20AM
1166
April 02, 2013 09:57PM
1138
April 10, 2013 08:31AM


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.