临时性设置MySQL隔离级别

1 问题背景

用sql玩隔离级别时需要临时性设置MySQL的隔离级别。因此了解设置隔离级别的相关sql语句。

参考自MySQL设置数据库隔离级别

2 知识

查看MySQL隔离级别：

# 查看全局隔离级别
select @@global.transaction_isolation;
# 查看会话隔离级别
select @@session.transaction_isolation;

设置全局隔离级别：

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;

设置会话隔离级别：

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;