MySQL Forums
Forum List  »  InnoDB

Re: incorrect/inefficient choice of index
Posted by: Brian Papantonio
Date: September 16, 2008 10:47PM

Depends on your definition of a "bug". MySQL constantly makes improvements to the way the optimizer performs, but it can never pick the 100% fastest execution plan for every single query.

In this case, the optimizer was "fixed" in 5.1.23 to have more predictable performance. It was later "unfixed" in 5.1.25...

Search for the section that reads "prefer full scan on clustered primary key":
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-25.html

-----------------------
MySQL 5.0 Certified DBA
MySQL 5.0 Certified Developer

Options: ReplyQuote


Subject
Views
Written By
Posted
3095
September 16, 2008 09:40PM
Re: incorrect/inefficient choice of index
1818
September 16, 2008 10:47PM


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.