1SET DEFAULT_STORAGE_ENGINE = 'tokudb'; 2DROP TABLE IF EXISTS foo; 3set session transaction isolation level repeatable read; 4create table foo (a int); 5select * from foo; 6a 7begin; 8insert into foo values (1),(2),(3); 9select * from foo; 10a 111 122 133 14rollback; 15select * from foo; 16a 17optimize table foo; 18Table Op Msg_type Msg_text 19test.foo optimize note Table does not support optimize, doing recreate + analyze instead 20test.foo optimize status OK 21select * from foo; 22a 23insert into foo values (1),(2),(3); 24select * from foo; 25a 261 272 283 29optimize table foo; 30Table Op Msg_type Msg_text 31test.foo optimize note Table does not support optimize, doing recreate + analyze instead 32test.foo optimize status OK 33select * from foo; 34a 351 362 373 38DROP TABLE foo; 39