一. 查看数据库的事物隔离级别
mysql> show variables like '%isolation';
+-----------------------+-----------------+
| Variable_name | Value |
+-----------------------+-----------------+
| transaction_isolation | REPEATABLE-READ | 新版本
| tx_isolation | REPEATABLE-READ | 旧版本
+-----------------------+-----------------+
2 rows in set (0.00 sec)
二. 修改本次会话的的事物隔离级别
mysql> SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
Query OK, 0 rows affected (0.00 sec)