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 ;
如果觉得《mysql8.0.22查看和设置数据库隔离级别》对你有帮助,请点赞、收藏,并留下你的观点哦!