1--disable_warnings 2DROP TABLE IF EXISTS t1; 3--enable_warnings 4 5CREATE TABLE t1 (a INT, INDEX (a)); 6INSERT INTO t1 VALUES (),(),(),(),(),(),(),(),(),(); 7 8FLUSH STATUS; 9SELECT a FROM t1 ORDER BY a LIMIT 1; 10SHOW STATUS LIKE 'HANDLER_READ%'; 11 12FLUSH STATUS; 13SELECT a FROM t1 ORDER BY a DESC LIMIT 1; 14SHOW STATUS LIKE 'HANDLER_READ%'; 15 16FLUSH STATUS; 17SELECT a FROM t1 ORDER BY a LIMIT 3; 18SHOW STATUS LIKE 'HANDLER_READ%'; 19 20FLUSH STATUS; 21SELECT a FROM t1 ORDER BY a DESC LIMIT 3; 22SHOW STATUS LIKE 'HANDLER_READ%'; 23 24DROP TABLE t1; 25 26