Debian Codegraph @

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

raw
1 SET GLOBAL INNODB_FILE_PER_TABLE= 0;
2 Warnings:
3 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
4 SET UNIQUE_CHECKS=0, FOREIGN_KEY_CHECKS=0;
5 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL,
6 f3 INT NOT NULL, INDEX(f1),
7 INDEX(f2), INDEX(f3))STATS_PERSISTENT=0 ENGINE=InnoDB;
8 BEGIN;
9 INSERT INTO t1 SELECT seq, seq, seq FROM seq_1_to_16384;
10 INSERT INTO t1 SELECT seq, seq, seq FROM seq_1_to_16384;
11 INSERT INTO t1 SELECT seq, seq, seq FROM seq_1_to_16384;
12 COMMIT;
13 DROP TABLE t1;
14 InnoDB 0 transactions not purged
15 SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
16 NAME FILE_SIZE
17 innodb_system 77594624
18 # restart
19 SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
20 NAME FILE_SIZE
21 innodb_system 10485760