查看并设置mysql隔离级别

1、查看当前会话的 隔离级别:

 select @@tx_isolation;

2、查看系统的隔离级别:

select @@global.tx_isolation;

3、设置会话的隔离级别，隔离级别由低到高设置依次为:

set session transaction isolation level read uncommitted;
set session transaction isolation level read committed;
set session transaction isolation level repeatable read;
set session transaction isolation level serializable;

4、设置当前系统的隔离级别，隔离级别由低到高设置依次为:

set global transaction isolation level read uncommitted;
set global transaction isolation level read committed;
set global transaction isolation level repeatable read;
set global transaction isolation level serializable;

注意：mysql默认的事务处理级别是'REPEATABLE-READ'，而Oracle和SQL Server是READ_COMMITED