blob: 2896411a42f3789cd49115332b29e0ece27c3d76 (
plain)
1
2
3
4
5
6
7
|
drop table if exists t1;
create table t1(a int not null auto_increment primary key) engine=innodb;
insert into t1 set a = -1;
optimize table t1;
Table Op Msg_type Msg_text
test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
test.t1 optimize status OK
|