mysql8.0 查询默认事务隔离级别

发表于2021-12-18更新于2021-12-18

MySQL8.0 已删除原来的 tx_isolation ，改用 transaction_isolation

1
2
3
transaction_isolation was added in MySQL 5.7.20 as an alias for tx_isolation, 
which is now deprecated and is removed in MySQL 8.0. 
Applications should be adjusted to use transaction_isolation in preference to tx_isolation.

查询默认事务隔离级别

1
2
3
1、show variables like 'transaction_isolation'\G;
2、select @@transaction_isolation\G;
3、SELECT @@GLOBAL.transaction_isolation, @@GLOBAL.transaction_read_only;

检查会话中的事务隔离级别

1
SELECT @@SESSION.transaction_isolation, @@SESSION.transaction_read_only;

设置事务隔离级别语法：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
SET [GLOBAL | SESSION] TRANSACTION
    transaction_characteristic [, transaction_characteristic] ...

transaction_characteristic: {
    ISOLATION LEVEL level
  | access_mode
}

level: {
     REPEATABLE READ
   | READ COMMITTED
   | READ UNCOMMITTED
   | SERIALIZABLE
}

access_mode: {
     READ WRITE
   | READ ONLY
}

To set the session isolation level, use any of these syntaxes: 

1
2
3
SET @@SESSION.transaction_isolation = value;
SET SESSION transaction_isolation = value;
SET transaction_isolation = value;

To set the next-transaction isolation level, use this syntax: 

1
SET @@transaction_isolation = value;