카테고리 없음
[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;