mysql事务隔离级别

查询事务隔离级别

 show variables like '%tx_isolation%'\G

设置事务隔离级别
读未提交

 SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

读已提交

SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;

可重复读

SET GLOBAL TRANSACTION ISOLATION LEVEL REPEATABLE READ;