Just saw this run by on the MySQL mailing list. Might help us?

(Also, I've enabled the 'slow query log' on the mysql server; I'll have a look at the results come tomorrow...)

-- brion vibber (brion @ pobox.com)

-----Forwarded Message-----

From: Heikki Tuuri <Heikki.Tuuri--innodb.com> To: mysql--lists.mysql.com, bugs--lists.mysql.com Subject: Major bug fixed in InnoDB optimizer in ... WHERE col > x Date: 28 Jan 2003 01:52:49 +0200

Hi!

Over the past 2 years several users have complained about optimization of queries of type

... WHERE col < x; ... WHERE col <= x; ... WHERE col > x; ... WHERE col >= x;

and, indeed, there was a major bug in the InnoDB query estimator. The fix appears in 4.0.10 and 3.23.56.

" MySQL/InnoDB-3.23.56, February xx, 2003

Fixed a major bug in InnoDB query optimization: queries of type SELECT ... WHERE indexcolumn < x and SELECT ... WHERE indexcolumn > x could cause a table scan even if the selectivity would have been very good. "

Best regards,

Heikki Innobase Oy

For mail filters: How-to-Repeat: sql query