Debian Codegraph @

mysql-test/suite/innodb/r/innodb_stats_persistent_debug.result

raw
1 #
2 # MDEV-13534 InnoDB STATS_PERSISTENT fails to ignore
3 # garbage delete-mark flag on node pointer pages
4 #
5 CREATE TABLE t(a INT UNSIGNED PRIMARY KEY)
6 ENGINE=InnoDB STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1;
7 BEGIN;
8 SET @save_debug = @@GLOBAL.innodb_limit_optimistic_insert_debug;
9 SET GLOBAL innodb_limit_optimistic_insert_debug=2;
10 INSERT t VALUES(1),(5);
11 DELETE FROM t;
12 INSERT t VALUES(4);
13 DELETE FROM t;
14 INSERT t VALUES(3);
15 DELETE FROM t;
16 SET GLOBAL innodb_limit_optimistic_insert_debug = @save_debug;
17 connect con1, localhost, root,,;
18 ANALYZE TABLE t;
19 Table Op Msg_type Msg_text
20 test.t analyze status Engine-independent statistics collected
21 test.t analyze status OK
22 disconnect con1;
23 connection default;
24 DROP TABLE t;