[ mysql修改事务隔离级别 ]

发表评论
195 views 

mysql> select @@tx_isolation;
+-----------------+
| @@tx_isolation  |
+-----------------+
| REPEATABLE-READ |
+-----------------+
1 row in set, 1 warning (0.00 sec)

mysql> set session transaction isolation level read committed;
Query OK, 0 rows affected (0.00 sec)
  • 与乐观锁配合使用READ-COMMITTED 读取已提交level级别
  • 默认事务级别REPEATABLE READ 可重复读level