--disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD INDEX i1 (c1); HANDLER t1 OPEN; SHOW GLOBAL STATUS LIKE 'Opened_tables'; let $cnt= 10; while ($cnt) { HANDLER t1 READ i1 =(12930) LIMIT 1; SHOW GLOBAL STATUS LIKE 'Opened_tables'; DELETE FROM t1 WHERE c1=12930; SHOW GLOBAL STATUS LIKE 'Opened_tables'; dec $cnt; } SHOW GLOBAL STATUS LIKE 'Opened_tables'; DROP TABLE t1;