Mysql 设置隔离级别_mysql如何设置隔离级别

如何查看mysql中的事务隔离级别：

查看系统隔离级别：select @@global.tx_isolation;
查看会话隔离级别(5.0以上版本)：select @@tx_isolation;
查看会话隔离级别(8.0以上版本)：select @@transaction_isolation;

如何修改mysql中的事务隔离级别：

可以通过命令行设置全局 或 会话的隔离级别。重启或者退出会话失效

设置全局隔离级别

set global transaction isolation level REPEATABLE READ;
 
set global transaction isolation level READ COMMITTED;
 
set global transaction isolation level READ UNCOMMITTED;
 
set global transaction isolation level SERIALIZABLE;

 设置会话隔离级别

set session transaction isolation level REPEATABLE READ;
 
set session transaction isolation level READ COMMITTED;
 
set session transaction isolation level READ UNCOMMITTED;
 
set session transaction isolation level SERIALIZABLE;

通过配置文件设置隔离级别

[mysqld]
 
transaction-isolation = REPEATABLE-READ
 
transaction-isolation = READ-COMMITTED
 
transaction-isolation = READ-UNCOMMITTED
 
transaction-isolation = SERIALIZABLE