1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
set default_storage_engine='tokudb';
drop table if exists t;
create table t (a int, b int, c int, primary key(a), key(b), key(c));
set tokudb_optimize_index_name='primary';
optimize table t;
Table Op Msg_type Msg_text
test.t optimize note Table does not support optimize, doing recreate + analyze instead
test.t optimize status OK
set tokudb_optimize_index_name='b';
optimize table t;
Table Op Msg_type Msg_text
test.t optimize note Table does not support optimize, doing recreate + analyze instead
test.t optimize status OK
set tokudb_optimize_index_name='c';
optimize table t;
Table Op Msg_type Msg_text
test.t optimize note Table does not support optimize, doing recreate + analyze instead
test.t optimize status OK
drop table t;
|
