示例:
1.隔离级别 read uncommitted
可以读取到另一个未结束事务的结果
mysql> select * from account; +-------+-------+ | uname | money | +-------+-------+ | zhang | 5000 | | li | 4000 | +-------+-------+ mysql> set session transaction isolation level read uncommitted; mysql> set transaction; mysql> update account set money = money +1000 where uname='li';
B窗口查看已到账,取款会提示超时
mysql> set session transaction isolation level read uncommitted; mysql> select * from account; +-------+-------+ | uname | money | +-------+-------+ | zhang | 5000 | | li | 5000 | +-------+-------+ mysql> update account set money=money -1000 where uname='li'; ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
2.隔离级别 read committed
可以读取到另一个结束事务的结果
A窗口
mysql> set session transaction isolation level read committed; mysql> start transaction; mysql> update account set money = money +1000 where uname='li'; mysql> commit;
B窗口
mysql> set session transaction isolation level read committed; mysql> start transaction; mysql> select * from account; mysql> select * from account; +-------+-------+ | uname | money | +-------+-------+ | zhang | 5000 | | li | 6000 | +-------+-------+
3.隔离级别 repeatable read (默认)
不能读取到另一个结束事务的结果
A窗口
mysql> set session transaction isolation level repeatable read; mysql> start transaction; mysql> update account set money = money +1000 where uname='li'; mysql> commit;
B窗口
mysql> set session transaction isolation level read committed; mysql> start transaction; mysql> select * from account; +-------+-------+ | uname | money | +-------+-------+ | zhang | 5000 | | li | 6000 | +-------+-------+



