mirror of
https://github.com/MariaDB/server.git
synced 2025-04-22 23:25:37 +02:00
36 lines
1.7 KiB
Text
36 lines
1.7 KiB
Text
--source include/have_innodb.inc
|
|
--source include/have_sequence.inc
|
|
let basedir=$MYSQLTEST_VARDIR/tmp/backup;
|
|
let incremental_dir=$MYSQLTEST_VARDIR/tmp/backup_inc1;
|
|
SET GLOBAL INNODB_FILE_PER_TABLE= 0;
|
|
CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL,
|
|
f3 INT NOT NULL, INDEX(f1),
|
|
INDEX(f2), INDEX(f3))ENGINE=InnoDB;
|
|
INSERT INTO t1 SELECT seq, seq, seq FROM seq_1_to_16384;
|
|
INSERT INTO t1 SELECT seq, seq, seq FROM seq_1_to_16384;
|
|
INSERT INTO t1 SELECT seq, seq, seq FROM seq_1_to_16384;
|
|
DROP TABLE t1;
|
|
--source ../innodb/include/wait_all_purged.inc
|
|
SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
|
|
--disable_result_log
|
|
exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --skip-innodb-log-checkpoint-now --parallel=10 --target-dir=$basedir --throttle=1000;
|
|
--enable_result_log
|
|
--source include/restart_mysqld.inc
|
|
SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
|
|
|
|
--echo # Incremental backup
|
|
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;
|
|
|
|
--disable_result_log
|
|
echo # Prepare full backup, apply incremental one;
|
|
exec $XTRABACKUP --prepare --target-dir=$basedir;
|
|
exec $XTRABACKUP --prepare --target-dir=$basedir --incremental-dir=$incremental_dir;
|
|
|
|
echo # Restore and check results;
|
|
let $targetdir=$basedir;
|
|
-- source include/restart_and_restore.inc
|
|
--enable_result_log
|
|
SELECT NAME, FILE_SIZE FROM information_schema.innodb_sys_tablespaces WHERE SPACE = 0;
|
|
# Cleanup
|
|
rmdir $basedir;
|
|
rmdir $incremental_dir;
|