1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
DROP TABLE IF EXISTS foo;
create table foo (a int) compression=tokudb_small;
select CREATE_OPTIONS from information_schema.tables where table_name='foo';
CREATE_OPTIONS
`compression`=tokudb_small
drop table foo;
create table foo (a int) compression=tokudb_fast;
select CREATE_OPTIONS from information_schema.tables where table_name='foo';
CREATE_OPTIONS
`compression`=tokudb_fast
drop table foo;
create table foo (a int) compression=tokudb_zlib;
select CREATE_OPTIONS from information_schema.tables where table_name='foo';
CREATE_OPTIONS
`compression`=tokudb_zlib
drop table foo;
create table foo (a int) compression=tokudb_lzma;
select CREATE_OPTIONS from information_schema.tables where table_name='foo';
CREATE_OPTIONS
`compression`=tokudb_lzma
drop table foo;
create table foo (a int) compression=tokudb_quicklz;
select CREATE_OPTIONS from information_schema.tables where table_name='foo';
CREATE_OPTIONS
`compression`=tokudb_quicklz
drop table foo;
create table foo (a int) compression=tokudb_uncompressed;
select CREATE_OPTIONS from information_schema.tables where table_name='foo';
CREATE_OPTIONS
`compression`=tokudb_uncompressed
drop table foo;
|