SET DEFAULT_STORAGE_ENGINE = 'tokudb'; # Establish connection conn1 (user = root) connect conn1,localhost,root,,; DROP TABLE IF EXISTS foo; connection default; create table foo (a int) engine=TokuDB; show create table foo; Table Create Table foo CREATE TABLE `foo` ( `a` int(11) DEFAULT NULL ) ENGINE=TokuDB DEFAULT CHARSET=latin1 insert into foo values (1); begin; insert into foo values (2); connection conn1; set session transaction isolation level serializable; begin; select * from foo; ERROR HY000: Lock wait timeout exceeded; try restarting transaction commit; set session transaction isolation level read uncommitted; select * from foo; a 1 2 connection default; commit; disconnect conn1; connection default; set session transaction isolation level serializable; DROP TABLE foo;