mysql read committed
来源:互联网 发布:linux查看发行版 编辑:程序博客网 时间:2024/05/18 17:27
read commit;
Oracle采用的也是 read committed
默认是:
mysql> SELECT @@GLOBAL.tx_isolation, @@tx_isolation;
+———————–+—————–+
| @@GLOBAL.tx_isolation | @@tx_isolation |
+———————–+—————–+
| REPEATABLE-READ | REPEATABLE-READ |
+———————–+—————–+
1 row in set (0.00 sec)
set session transaction isolation level read committed;
mysql> SELECT @@GLOBAL.tx_isolation, @@tx_isolation;
+———————–+—————-+
| @@GLOBAL.tx_isolation | @@tx_isolation |
+———————–+—————-+
| REPEATABLE-READ | READ-COMMITTED |
+———————–+—————-+
1 row in set (0.00 sec)
SESSION A:
set autocommit=0;
set session transaction isolation level read committed;
SESSION B:
set autocommit=0;
set session transaction isolation level read committed;
SESSION B:
mysql> insert into t1 values(200);
Query OK, 1 row affected (0.00 sec)
mysql> select * from t1;
+——+
| id |
+——+
| 100 |
| 200 |
+——+
2 rows in set (0.00 sec)
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
SESSION A:
mysql> select * from t1;
+——+
| id |
+——+
| 100 |
| 200 |
+——+
2 rows in set (0.00 sec
只要B提交,A就能看到
- mysql read committed
- mysql事务之提交读(Read Committed)
- Mysql事务和隔离级别(read committed, repeatable read)
- mysql binlog格式与事务级别read committed的关系
- mysql READ-COMMITTED 模式下 行锁不会升级到表级锁
- Mysql的READ COMMITTED隔离级别的问题
- read repeatable&read committed 区别
- MYSQL下read committed 和repeatable read级别下一致性非锁定读笔记+实测
- Read Committed与Read committed snapshot的区别以及Read Committed Snapshot与Sanpshot的区别
- REPEATABLE-READ和READ-COMMITTED幻读
- MYSQL:Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'
- 数据库隔离级别---MySQL的默认隔离级别就是Repeatable,Oracle默认Read committed,最高级别Serializable
- informix隔离级别:committed read last committed与committed read介绍
- Read Committed Snapshot Isolation和Snapshot Isolation
- Read Committed Snapshot和Snapshot Isolation
- Read Committed Snapshot和Snapshot Isolation
- MySql之错误异常--Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is no
- java 默认事务级别read committed对binlog_format的需求
- Referenced file contains errors 解决方法 (转载地址:http://blog.sina.com.cn/s/blog_6a6b141001011xhn.html)
- 【第8周 项目2 - 建立链串的算法库】
- 第六届校内赛B组
- 漫威超级英雄大全(一)
- scu 2057 树状数组 单点更新区间求和问题
- mysql read committed
- lightswitch datagrid 动态添加复选框的功能。
- Android开发之SurfaceView详解
- 数组大小分配问题及相关问题
- 記号の読み方
- 设置QT 无框架,,,无最小化,最大化
- 黑马程序员-集合(2)
- UVa 11800 - Determine the Shape
- git 相关