隔离级别

查看隔离级别
MySQL8.0 查看当前会话的隔离级别:select @@transaction_isolation;
非 8.0 版本查看当前会话的隔离级别:select @@tx_isolation;
show variables like '%tx_isolation%' 同样适用。


修改隔离级别
set [session | global] transaction isolation level {read uncommitted | read committed | repeatable read | serializable}