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