innodb-autoinc-optimize.result 321 Bytes
Newer Older
1 2 3 4 5
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
6
test.t1	optimize	note	Table does not support optimize, doing recreate + analyze instead
7
test.t1	optimize	status	OK
8 9
==== clean up ====
DROP TABLE t1;