Debian Codegraph @

mysql-test/suite/mariabackup/compression_providers_loaded.result

raw
1 #
2 # Testing mariabackup with bzip2 compression
3 #
4 # Creating table
5 set global innodb_compression_algorithm = bzip2;
6 create table t1 (a int, b text ) engine = innodb page_compressed = 1;
7 insert t1 (a, b) values (0, repeat("abc", 100));
8 insert t1 (a, b) values (1, repeat("def", 1000));
9 insert t1 (a, b) values (2, repeat("ghi", 10000));
10 select a, left(b, 9), length(b) from t1;
11 a left(b, 9) length(b)
12 0 abcabcabc 300
13 1 defdefdef 3000
14 2 ghighighi 30000
15 # restart
16 # xtrabackup backup
17 # xtrabackup prepare;
18 # shutdown server
19 # remove datadir
20 # xtrabackup move back
21 # restart
22 select a, left(b, 9), length(b) from t1;
23 a left(b, 9) length(b)
24 0 abcabcabc 300
25 1 defdefdef 3000
26 2 ghighighi 30000
27 drop table t1;