PROTECTED]; [EMAIL PROTECTED]
[EMAIL PROTECTED]
Date: Thursday, February 14, 2002 3:44 AM
Subject: RE: Does delete from .. where (condition) use an index?
Heikki,
mysql EXPLAIN SELECT * FROM Syslog WHERE datestamp = 2002021310712
Mayers; [EMAIL PROTECTED]
Subject: Re: Does delete from .. where (condition) use an index?
Eric,
print what
EXPLAIN SELECT * FROM Syslog USE INDEX(ds_index) WHERE ...
says.
Please also show what the InnoDB monitor prints.
Regards,
Heikki
-Original Message-
From
5:59 PM
To: Eric Mayers; [EMAIL PROTECTED]
Subject: Re: Does delete from .. where (condition) use an index?
Eric,
print what
EXPLAIN SELECT * FROM Syslog USE INDEX(ds_index) WHERE ...
says.
Please also show what the InnoDB monitor prints.
Regards,
Heikki
-Original Message
Eric,
-Original Message-
From: Eric Mayers [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Date: Friday, February 15, 2002 1:10 AM
Subject: RE: Does delete from .. where (condition) use an index?
Heikki,
I thought I'd bring this off the list to reduce list traffic (if you
think
Eric,
MySQL is very pessimistic about key accesses: it assumes many of them cause
a random disk read.
Please print
EXPLAIN SELECT * FROM Syslog WHERE datestamp ...
to see how it accesses the table.
I have tuned the optimization in 3.23.48 so that it would favor index
searches more often.
]
Subject: Re: Does delete from .. where (condition) use an index?
Eric,
MySQL is very pessimistic about key accesses: it assumes many
of them cause
a random disk read.
Please print
EXPLAIN SELECT * FROM Syslog WHERE datestamp ...
to see how it accesses the table.
I have tuned
: Thursday, February 14, 2002 3:44 AM
Subject: RE: Does delete from .. where (condition) use an index?
Heikki,
mysql EXPLAIN SELECT * FROM Syslog WHERE datestamp = 2002021310712;
++--+---+--+-+--+-+-
---+
| table | type | possible_keys | key