MySQL

【MySQL】设置隔离级别（Isolation Levels）

Posted by 西维蜀黍 on 2023-07-20, Last Modified on 2023-07-26

Show Transaction Isolation Level

check session transaction level (mysql8+)

SELECT @@transaction_ISOLATION;

check global transaction level (mysql8+)

SELECT @@global.transaction_ISOLATION;

Set Transaction Isolation Level

# set global
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
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;

Reference

FEATURED TAGS
algorithm algorithmproblem architecturalpattern architecture aws c# cachesystem codis concurrentcontrol database dataformat datastructure debug design designpattern distributedsystem django docker domain engineering freebsd git golang grafana hackintosh hadoop hardware hexo http hugo ios iot java javaee javascript kafka kubernetes linux linuxcommand linuxio lock macos markdown microservices mysql nas network networkprogramming nginx node.js npm oop openwrt operatingsystem padavan performance programming prometheus protobuf python redis router security shell software testing spring sql systemdesign truenas ubuntu vmware vpn windows wmware wordpress xml zookeeper
FRIENDS

TOC