一. 查看数据库的事物隔离级别

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)