Debian Codegraph @

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

raw
1 # restart: --debug_dbug=d,undo_segment_leak
2 SET GLOBAL INNODB_FILE_PER_TABLE=0;
3 Warnings:
4 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
5 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL)ENGINE=InnoDB;
6 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_4096;
7 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_4096;
8 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_4096;
9 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_4096;
10 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_4096;
11 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_4096;
12 UPDATE t1 SET f1 = f1 + 1 WHERE f1 > 1000;
13 UPDATE t1 SET f2 = f2 + 1 WHERE f1 > 1000;
14 UPDATE t1 SET f1 = f2 + 1 WHERE f1 > 1000;
15 UPDATE t1 SET f2 = f1 + 1 WHERE f1 > 1000;
16 DELETE FROM t1;
17 DROP TABLE t1;
18 set GLOBAL innodb_fast_shutdown=0;
19 SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
20 NAME FILE_SIZE
21 innodb_system 79691776
22 # restart
23 SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
24 NAME FILE_SIZE
25 innodb_system 12582912