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); select * from foo; a 1 rollback; select * from foo; a set session transaction isolation level read committed; begin; insert into foo values (1); select * from foo; a 1 rollback; select * from foo; a DROP TABLE foo;