1# Establish connection conn1 (user = root) 2connect conn1,localhost,root,,; 3SET DEFAULT_STORAGE_ENGINE = 'tokudb'; 4DROP TABLE IF EXISTS foo,foo_isam; 5connection conn1; 6set session transaction isolation level read uncommitted; 7create table foo ( a int, b int, primary key (a)); 8insert into foo values (1,1),(2,2),(3,1),(4,3); 9select * from foo; 10a b 111 1 122 2 133 1 144 3 15begin; 16update foo set b=10 where b=1; 17select * from foo; 18a b 191 10 202 2 213 10 224 3 23connection default; 24insert into foo values (5,5); 25ERROR HY000: Lock wait timeout exceeded; try restarting transaction 26connection conn1; 27rollback; 28select * from foo; 29a b 301 1 312 2 323 1 334 3 34begin; 35delete from foo where b=2; 36select * from foo; 37a b 381 1 393 1 404 3 41connection default; 42insert into foo values (5,5); 43ERROR HY000: Lock wait timeout exceeded; try restarting transaction 44connection conn1; 45rollback; 46select * from foo; 47a b 481 1 492 2 503 1 514 3 52create table foo_isam (a int, b int)engine=MyISAM; 53begin; 54insert into foo_isam select * from foo; 55connection default; 56insert into foo values (5,5); 57select * from foo; 58a b 591 1 602 2 613 1 624 3 635 5 64connection conn1; 65commit; 66connection default; 67disconnect conn1; 68connection default; 69set session transaction isolation level serializable; 70DROP TABLE foo, foo_isam; 71