Created
May 16, 2024 13:49
-
-
Save spetrunia/ac0d2e64891c143428d79a0ac0e764f7 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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