[Maria/MySQL] How to check transaction isolation level and set isolation level.(트랜잭션 Isolation level 확인)

1. Check Trasaction Isolation Level

1-1. Global Level
SELECT @@global.tx_isolation;

1-2. Sesssion Level
SELECT @@tx_isolation;


2. Set Isolaction Level

2-1. Edit Configure file
[myslqd]
transaction-isolation = [READ-UNCOMMITTED | READ-COMMITTED | REPEATABLE-READ | SERIALIZABLE]

2-2. Using command
SET @@[SESSION | GLOBAL].tx_isolation = '[READ-UNCOMMITTED | READ-COMMITTED | REPEATABLE-READ | SERIALIZABLE]';