mysql8.0.22查看和设置数据库隔离级别

select @@version;

select @@transaction_isolation;

set session transaction isolation level read committed;
select @@transaction_isolation;

数据库隔离级别

读未提交（READ UNCOMMITTED）
读提交 （READ COMMITTED）
可重复读 （REPEATABLE READ）
串行化 （SERIALIZABLE）
可重复读是 MySQL 的默认级别。

sql语句设置当前session隔离级别

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 ;

设置全局隔离级别

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 ;