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; |