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