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