Debian Codegraph @

mysql-test/suite/mariabackup/sys_truncate.test

raw
1 --source include/have_innodb.inc
2 --source include/have_sequence.inc
3 let basedir=$MYSQLTEST_VARDIR/tmp/backup;
4 let incremental_dir=$MYSQLTEST_VARDIR/tmp/backup_inc1;
5 SET GLOBAL INNODB_FILE_PER_TABLE= 0;
6 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL,
7 f3 INT NOT NULL, INDEX(f1),
8 INDEX(f2), INDEX(f3))ENGINE=InnoDB;
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 DROP TABLE t1;
13 --source ../innodb/include/wait_all_purged.inc
14 SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
15 --disable_result_log
16 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --skip-innodb-log-checkpoint-now --parallel=10 --target-dir=$basedir --throttle=1000;
17 --enable_result_log
18 --source include/restart_mysqld.inc
19 SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
20
21 --echo # Incremental backup
22 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --skip-innodb-log-checkpoint-now --parallel=2 --ftwrl-wait-timeout=5 --ftwrl-wait-threshold=300 --ftwrl-wait-query-type=all --target-dir=$incremental_dir --incremental-basedir=$basedir;
23
24 --disable_result_log
25 echo # Prepare full backup, apply incremental one;
26 exec $XTRABACKUP --prepare --target-dir=$basedir;
27 exec $XTRABACKUP --prepare --target-dir=$basedir --incremental-dir=$incremental_dir;
28
29 echo # Restore and check results;
30 let $targetdir=$basedir;
31 -- source include/restart_and_restore.inc
32 --enable_result_log
33 SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
34 # Cleanup
35 rmdir $basedir;
36 rmdir $incremental_dir;