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