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