mysql事务隔离级别设置与查看

1.查看当前会话隔离级别

 

select @@tx_isolation;

 

2.查看系统当前隔离级别

 

select @@global.tx_isolation;

 

3.设置当前会话隔离级别

 

set session transaction isolation level Read Uncommitted;

 

4.设置系统当前隔离级别

 

set global transaction isolation level repeatable read;

 

5.命令行，开始事务时

 

set autocommit=off 或者 start transaction