SET DEFAULT_STORAGE_ENGINE = 'tokudb';
DROP TABLE IF EXISTS foo;
set session transaction isolation level repeatable read;
create table foo (a int);
select * from foo;
a
begin;
insert into foo values (1),(2),(3);
select * from foo;
a
1
2
3
rollback;
select * from foo;
a
optimize table foo;
Table	Op	Msg_type	Msg_text
test.foo	optimize	note	Table does not support optimize, doing recreate + analyze instead
test.foo	optimize	status	OK
select * from foo;
a
insert into foo values (1),(2),(3);
select * from foo;
a
1
2
3
optimize table foo;
Table	Op	Msg_type	Msg_text
test.foo	optimize	note	Table does not support optimize, doing recreate + analyze instead
test.foo	optimize	status	OK
select * from foo;
a
1
2
3
DROP TABLE foo;