MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)
Posted by: Chris Ricks
Date: February 02, 2012 03:06AM

It looks like the problem is actually quite simple.

For some incredibly strange reason, having an ORDER BY clause causes selection of the index that can be used to satisfy the ORDER BY without filesort as opposed to selection of the index that can actually return the results in a respectable amount of time.

No amount of playing with max_length_for_sort_data is helping this.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)
2892
Chris Ricks
February 02, 2012 01:17AM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)
1200
Chris Ricks
February 01, 2012 07:33PM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)
1222
Chris Ricks
February 02, 2012 03:06AM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)
1107
Øystein Grøvlen
February 02, 2012 03:58AM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)
1146
Chris Ricks
February 02, 2012 04:43AM
Re: MySQL 5.5 Query Optimizer - Massive Regression (vs 5.0)
1119
Rick James
February 03, 2012 11:57PM


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.