blob: c6da43555b29dfcdcb16ab25cbdb37d9e802a545 (
plain)
1
2
3
4
5
6
7
8
9
|
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
==== clean up ====
DROP TABLE t1;
|