栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

【MYSQL优化32】事务

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

【MYSQL优化32】事务


示例:

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 |
+-------+-------+
转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/978339.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号