Debian Codegraph @

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

raw
1 #
2 # MDEV-35398 Improve shrinking of system tablespace
3 #
4 # restart: --debug_dbug=d,skip_cached_undo
5 SET GLOBAL innodb_file_per_table= 0;
6 Warnings:
7 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
8 CREATE TABLE t1(f1 INT PRIMARY KEY)ENGINE=InnoDB;
9 CREATE TABLE t2(f1 INT PRIMARY KEY)ENGINE=InnoDB;
10 SET STATEMENT unique_checks=0,foreign_key_checks=0 FOR
11 INSERT INTO t1 SELECT seq FROM seq_1_to_24576;
12 SET STATEMENT unique_checks=0,foreign_key_checks=0 FOR
13 INSERT INTO t2 SELECT seq FROM seq_1_to_24576;
14 # Insert 34 transaction which has undo cached records
15 DROP TABLE t2, t1;
16 SET GLOBAL innodb_fast_shutdown=0;
17 SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
18 NAME FILE_SIZE
19 innodb_system 79691776
20 # restart
21 SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
22 NAME FILE_SIZE
23 innodb_system 12582912