Debian Codegraph @

mysql-test/suite/innodb/r/innodb-stats-modified-counter.result

raw
1 set global innodb_stats_auto_recalc=off;
2 CREATE TABLE t1 (i int) ENGINE=InnoDB;
3 SELECT NAME, STATS_INITIALIZED, NUM_ROWS, MODIFIED_COUNTER FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS WHERE NAME = 'test/t1';
4 NAME STATS_INITIALIZED NUM_ROWS MODIFIED_COUNTER
5 test/t1 1 0 0
6 INSERT INTO t1 VALUES (1);
7 INSERT INTO t1 VALUES (2);
8 SELECT NAME, STATS_INITIALIZED, NUM_ROWS, MODIFIED_COUNTER FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS WHERE NAME = 'test/t1';
9 NAME STATS_INITIALIZED NUM_ROWS MODIFIED_COUNTER
10 test/t1 1 2 2
11 DELETE FROM t1 WHERE i = 1;
12 SELECT NAME, STATS_INITIALIZED, NUM_ROWS, MODIFIED_COUNTER FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS WHERE NAME = 'test/t1';
13 NAME STATS_INITIALIZED NUM_ROWS MODIFIED_COUNTER
14 test/t1 1 1 3
15 UPDATE t1 SET i = 4 WHERE i = 2;
16 SELECT NAME, STATS_INITIALIZED, NUM_ROWS, MODIFIED_COUNTER FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS WHERE NAME = 'test/t1';
17 NAME STATS_INITIALIZED NUM_ROWS MODIFIED_COUNTER
18 test/t1 1 1 4
19 DROP TABLE t1;
20 set global innodb_stats_auto_recalc=default;