1drop table if exists t1; 2create table t1(a int not null auto_increment primary key) engine=innodb; 3insert into t1 set a = -1; 4optimize table t1; 5Table Op Msg_type Msg_text 6test.t1 optimize note Table does not support optimize, doing recreate + analyze instead 7test.t1 optimize status OK 8==== clean up ==== 9DROP TABLE t1; 10