1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
FLUSH STATUS; SHOW STATUS LIKE 'Handler_delete'; CREATE TABLE t1 (a int primary key); INSERT INTO t1 VALUES (1); DELETE FROM t1; SHOW STATUS LIKE 'Handler_delete'; INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7); SHOW STATUS LIKE 'Handler_delete'; DELETE FROM t1 WHERE a=4; SHOW STATUS LIKE 'Handler_delete'; DELETE FROM t1 WHERE a > 2; INSERT INTO t1 VALUES (3),(4),(5); SHOW STATUS LIKE 'Handler_delete'; DROP TABLE t1; FLUSH STATUS; |