Re: After partition also select is scanning all the partitions - need help

[Rick James]

No fair -- you keep changing the dates.

mysql> select count(*) from ServerPerfStore where Date='2010-09-17' \G
*************************** 1. row ***************************
count(*): 399
-- versus --
mysql> select * from mytable where mytime >= '2010-09-04 00:00:00' and mytime <= '2010-09-07 00:00:00';
8162 rows in set (0.08 sec)

And even the table!

By the way, you probably don't want to include midnight in
and mytime <= '2010-09-07 00:00:00'

Looks like you can do just this for experimenting further:
SHOW SESSION STATUS LIKE 'Handler_read_next';