mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +01:00
33 lines
1.3 KiB
Text
33 lines
1.3 KiB
Text
select plugin_name, plugin_status from information_schema.plugins where plugin_name='provider_lz4';
|
|
plugin_name plugin_status
|
|
set global innodb_compression_algorithm = lz4;
|
|
ERROR 42000: Variable 'innodb_compression_algorithm' can't be set to the value of 'lz4'
|
|
install plugin provider_lz4 soname 'provider_lz4';
|
|
select plugin_name, plugin_status from information_schema.plugins where plugin_name='provider_lz4';
|
|
plugin_name plugin_status
|
|
provider_lz4 ACTIVE
|
|
set global innodb_compression_algorithm = lz4;
|
|
create table t1 (a int, b text) engine=innodb page_compressed=1;
|
|
insert t1 (a, b) values (0, repeat("abc", 100));
|
|
insert t1 (a, b) values (1, repeat("def", 1000));
|
|
insert t1 (a, b) values (2, repeat("ghi", 10000));
|
|
select a, left(b, 9), length(b) from t1;
|
|
a left(b, 9) length(b)
|
|
0 abcabcabc 300
|
|
1 defdefdef 3000
|
|
2 ghighighi 30000
|
|
uninstall plugin provider_lz4;
|
|
Warnings:
|
|
Warning 1620 Plugin is busy and will be uninstalled on shutdown
|
|
select plugin_name, plugin_status from information_schema.plugins where plugin_name='provider_lz4';
|
|
plugin_name plugin_status
|
|
provider_lz4 INACTIVE
|
|
set global innodb_compression_algorithm = default;
|
|
set global innodb_compression_algorithm = lz4;
|
|
set global innodb_compression_algorithm = default;
|
|
select a, left(b, 9), length(b) from t1;
|
|
a left(b, 9) length(b)
|
|
0 abcabcabc 300
|
|
1 defdefdef 3000
|
|
2 ghighighi 30000
|
|
drop table t1;
|