2
SHOW STATUS LIKE 'Handler_delete';
5
CREATE TABLE t1 (a int primary key);
6
INSERT INTO t1 VALUES (1);
8
SHOW STATUS LIKE 'Handler_delete';
11
INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7);
12
SHOW STATUS LIKE 'Handler_delete';
15
DELETE FROM t1 WHERE a=4;
16
SHOW STATUS LIKE 'Handler_delete';
19
DELETE FROM t1 WHERE a > 2;
20
INSERT INTO t1 VALUES (3),(4),(5);
21
SHOW STATUS LIKE 'Handler_delete';