Debian Codegraph @

mysql-test/suite/plugins/r/compression_load.result

raw
1 select plugin_name, plugin_status from information_schema.plugins where plugin_name='provider_lz4';
2 plugin_name plugin_status
3 set global innodb_compression_algorithm = lz4;
4 ERROR 42000: Variable 'innodb_compression_algorithm' can't be set to the value of 'lz4'
5 install plugin provider_lz4 soname 'provider_lz4';
6 select plugin_name, plugin_status from information_schema.plugins where plugin_name='provider_lz4';
7 plugin_name plugin_status
8 provider_lz4 ACTIVE
9 set global innodb_compression_algorithm = lz4;
10 create table t1 (a int, b text) engine=innodb page_compressed=1;
11 insert t1 (a, b) values (0, repeat("abc", 100));
12 insert t1 (a, b) values (1, repeat("def", 1000));
13 insert t1 (a, b) values (2, repeat("ghi", 10000));
14 select a, left(b, 9), length(b) from t1;
15 a left(b, 9) length(b)
16 0 abcabcabc 300
17 1 defdefdef 3000
18 2 ghighighi 30000
19 uninstall plugin provider_lz4;
20 Warnings:
21 Warning 1620 Plugin is busy and will be uninstalled on shutdown
22 select plugin_name, plugin_status from information_schema.plugins where plugin_name='provider_lz4';
23 plugin_name plugin_status
24 provider_lz4 INACTIVE
25 set global innodb_compression_algorithm = default;
26 set global innodb_compression_algorithm = lz4;
27 set global innodb_compression_algorithm = default;
28 select a, left(b, 9), length(b) from t1;
29 a left(b, 9) length(b)
30 0 abcabcabc 300
31 1 defdefdef 3000
32 2 ghighighi 30000
33 drop table t1;