查看和修改MySQL数据库的事物隔离级别
查看MySQL的事物隔离级别
mysql> show variables like '%isolation%';
+
| Variable_name | Value |
+
| tx_isolation | REPEATABLE-READ |
+
1 row in set (0.00 sec)
mysql> select @@global.tx_isolation, @@tx_isolation;
+
| @@global.tx_isolation | @@tx_isolation |
+
| REPEATABLE-READ | REPEATABLE-READ |
+
1 row in set (0.00 sec)
修改MySQL数据库的事物隔离级别
mysql> help ISOLATION
Name: 'ISOLATION'
Description:
Syntax:
SET [GLOBAL | SESSION] TRANSACTION ISOLATION LEVEL
{
REPEATABLE READ
| READ COMMITTED
| READ UNCOMMITTED
| SERIALIZABLE
}