Debian Codegraph @

mysql-test/suite/mariabackup/page_compression_level.test

raw
1 #--source include/innodb_page_size.inc
2
3 set global innodb_compression_level = 3;
4 CREATE TABLE t1(c1 INT, b CHAR(20)) ENGINE=INNODB PAGE_COMPRESSED=1;
5 INSERT INTO t1 VALUES(1, 'mariadb');
6
7 echo # xtrabackup backup;
8 let $targetdir=$MYSQLTEST_VARDIR/tmp/backup;
9
10 --disable_result_log
11 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir;
12 echo # xtrabackup prepare;
13 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --defaults-group-suffix=.1 --prepare --export --target-dir=$targetdir;
14 --enable_result_log
15
16 --let SEARCH_PATTERN=innodb_compression_level=3
17 --let SEARCH_FILE=$targetdir/backup-my.cnf
18 --source include/search_pattern_in_file.inc
19
20 DELETE FROM t1;
21 ALTER TABLE t1 DISCARD TABLESPACE;
22 let $MYSQLD_DATADIR= `select @@datadir`;
23 copy_file $targetdir/test/t1.ibd $MYSQLD_DATADIR/test/t1.ibd;
24 copy_file $targetdir/test/t1.cfg $MYSQLD_DATADIR/test/t1.cfg;
25 ALTER TABLE t1 IMPORT TABLESPACE;
26
27 SELECT * FROM t1;
28
29 DROP TABLE t1;
30 set global innodb_compression_level = default;
31 rmdir $targetdir;