Debian Codegraph @

mysql-test/suite/mariabackup/page_compression_level.result

raw
1 set global innodb_compression_level = 3;
2 CREATE TABLE t1(c1 INT, b CHAR(20)) ENGINE=INNODB PAGE_COMPRESSED=1;
3 INSERT INTO t1 VALUES(1, 'mariadb');
4 # xtrabackup backup
5 # xtrabackup prepare
6 FOUND 1 /innodb_compression_level=3/ in backup-my.cnf
7 DELETE FROM t1;
8 ALTER TABLE t1 DISCARD TABLESPACE;
9 ALTER TABLE t1 IMPORT TABLESPACE;
10 SELECT * FROM t1;
11 c1 b
12 1 mariadb
13 DROP TABLE t1;
14 set global innodb_compression_level = default;