Debian Codegraph @

mysql-test/suite/mariabackup/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 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL,
5 f3 INT NOT NULL, INDEX(f1),
6 INDEX(f2), INDEX(f3))ENGINE=InnoDB;
7 INSERT INTO t1 SELECT seq, seq, seq FROM seq_1_to_16384;
8 INSERT INTO t1 SELECT seq, seq, seq FROM seq_1_to_16384;
9 INSERT INTO t1 SELECT seq, seq, seq FROM seq_1_to_16384;
10 DROP TABLE t1;
11 InnoDB 0 transactions not purged
12 SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
13 NAME FILE_SIZE
14 innodb_system 70254592
15 # restart
16 SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
17 NAME FILE_SIZE
18 innodb_system 3145728
19 # Incremental backup
20 # Prepare full backup, apply incremental one
21 # Restore and check results
22 # shutdown server
23 # remove datadir
24 # xtrabackup move back
25 # restart
26 SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
27 NAME FILE_SIZE
28 innodb_system 3145728