1
# Establish connection conn1 (user = root)
2
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
3
DROP TABLE IF EXISTS foo;
4
set session transaction isolation level read committed;
5
create table foo ( a int, b int, primary key (a));
6
insert into foo values (1,1),(2,2),(3,1),(4,3);
14
update foo set b=10 where b=1;
21
set session transaction isolation level read committed;
28
set session transaction isolation level read uncommitted;
37
insert into foo values (5,1),(6,2),(7,1),(8,3);
48
set session transaction isolation level read committed;
55
set session transaction isolation level read uncommitted;
68
delete from foo where b=1;
75
set session transaction isolation level read committed;
86
set session transaction isolation level read uncommitted;
94
set session transaction isolation level serializable;