Skip to content

Instantly share code, notes, and snippets.

@spetrunia
Created May 16, 2024 13:49
Show Gist options
  • Save spetrunia/ac0d2e64891c143428d79a0ac0e764f7 to your computer and use it in GitHub Desktop.
Save spetrunia/ac0d2e64891c143428d79a0ac0e764f7 to your computer and use it in GitHub Desktop.
diff --git a/mysql-test/main/_b1.opt b/mysql-test/main/_b1.opt
new file mode 100644
index 00000000000..a5bb9a93636
--- /dev/null
+++ b/mysql-test/main/_b1.opt
@@ -0,0 +1 @@
+--innodb_buffer_pool_dump_at_shutdown=off --innodb_buffer_pool_load_at_startup=off --innodb-stats-persistent=1 --innodb-stats-auto-recalc=off
diff --git a/mysql-test/main/_b1.test b/mysql-test/main/_b1.test
new file mode 100644
index 00000000000..fbbb564721d
--- /dev/null
+++ b/mysql-test/main/_b1.test
@@ -0,0 +1,30 @@
+--source include/have_innodb.inc
+--source include/have_sequence.inc
+
+
+# Each row is 1K.
+create table t1 (
+ a varchar(255),
+ b varchar(255),
+ c varchar(255),
+ d varchar(255)
+) engine=innodb;
+
+# The data is 16K * 1K = 16M
+# 16M / (page_size=16K) = 1K pages.
+insert into t1 select
+# repeat('abc-', 63),
+ repeat(uuid(), 7),
+ repeat(uuid(), 7),
+ repeat(uuid(), 7),
+ repeat(uuid(), 7)
+from seq_1_to_163840;
+insert into t1 values ('z','z','z','z');
+show status like '%innodb%page%';
+
+source include/restart_mysqld.inc;
+show status like '%innodb%page%';
+
+analyze format=json select max(c) from t1;
+
+drop table t1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment