1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
drop table if exists t1;
create table t1 (c1 int not null primary key, c2 int not null) engine=tokudb;
show create table t1;
Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` int(11) NOT NULL,
PRIMARY KEY (`c1`)
) ENGINE=TokuDB DEFAULT CHARSET=latin1 `compression`='tokudb_zlib'
insert into t1 (c1,c2) values (1,1),(2,2);
alter table t1 compression=tokudb_lzma;
show create table t1;
Table Create Table
t1 CREATE TABLE `t1` (
`c1` int(11) NOT NULL,
`c2` int(11) NOT NULL,
PRIMARY KEY (`c1`)
) ENGINE=TokuDB DEFAULT CHARSET=latin1 `compression`=tokudb_lzma
drop table t1;
|
