Debian Codegraph @

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

raw
1 # MDEV-33101 Server crashes when starting the server with
2 # innodb-force-recovery=6 and enabling the
3 # innodb_truncate_temporary_tablespace_now variable
4 # restart: --innodb-force-recovery=6
5 SHOW VARIABLES LIKE "innodb_read_only";
6 Variable_name Value
7 innodb_read_only ON
8 SET GLOBAL innodb_truncate_temporary_tablespace_now=1;
9 # restart
10 CREATE TEMPORARY TABLE t1(f1 INT NOT NULL,
11 f2 INT NOT NULL)ENGINE=InnoDB;
12 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_65536;
13 DROP TABLE t1;
14 SELECT NAME, FILE_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE=4294967294;
15 NAME FILE_SIZE
16 innodb_temporary 72351744
17 SET GLOBAL INNODB_TRUNCATE_TEMPORARY_TABLESPACE_NOW= 0;
18 SELECT NAME, FILE_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE=4294967294;
19 NAME FILE_SIZE
20 innodb_temporary 72351744
21 SET GLOBAL INNODB_TRUNCATE_TEMPORARY_TABLESPACE_NOW= 1;
22 SELECT NAME, FILE_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE= 4294967294;
23 NAME FILE_SIZE
24 innodb_temporary 5242880
25 CREATE TEMPORARY TABLE t1(f1 INT NOT NULL,
26 f2 INT NOT NULL)ENGINE=InnoDB;
27 BEGIN;
28 INSERT INTO t1 SELECT seq, seq FROM seq_1_to_65536;
29 connect con1,localhost,root,,,;
30 CREATE TEMPORARY TABLE t2(f1 INT NOT NULL,
31 f2 INT NOT NULL)ENGINE=InnoDB;
32 INSERT INTO t2 SELECT seq, seq FROM seq_1_to_65536;
33 DROP TABLE t2;
34 SELECT NAME, FILE_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE=4294967294;
35 NAME FILE_SIZE
36 innodb_temporary 72351744
37 SET GLOBAL INNODB_TRUNCATE_TEMPORARY_TABLESPACE_NOW= 1;
38 SELECT NAME, FILE_SIZE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE= 4294967294;
39 NAME FILE_SIZE
40 innodb_temporary 7340032
41 connection default;
42 COMMIT;
43 SELECT COUNT(*) FROM t1;
44 COUNT(*)
45 65536
46 DROP TABLE t1;