develog

[mariadb] deadlock, isolation level 본문

카테고리 없음

[mariadb] deadlock, isolation level

냐옴 2025. 3. 13. 16:20

 

-- deadlock 확인
show engine innodb status;

-- isolation 확인
select @@global.tx_isolation, @@session.tx_isolation;

-- 글로벌 isolation 레벨 변경
SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;

-- 세션 isolation 레벨 변경
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
저작자표시 비영리 동일조건
Comments