# # MDEV-13534 InnoDB STATS_PERSISTENT fails to ignore # garbage delete-mark flag on node pointer pages # CREATE TABLE t(a INT UNSIGNED PRIMARY KEY) ENGINE=InnoDB STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1; BEGIN; SET @save_debug = @@GLOBAL.innodb_limit_optimistic_insert_debug; SET GLOBAL innodb_limit_optimistic_insert_debug=2; INSERT t VALUES(1),(5); DELETE FROM t; INSERT t VALUES(4); DELETE FROM t; INSERT t VALUES(3); DELETE FROM t; SET GLOBAL innodb_limit_optimistic_insert_debug = @save_debug; connect con1, localhost, root,,; ANALYZE TABLE t; Table Op Msg_type Msg_text test.t analyze status Engine-independent statistics collected test.t analyze status OK disconnect con1; connection default; DROP TABLE t;