MySQL tx isolation

1 개요

transaction-isolation

tx_isolation

MariaDB [(none)]> SELECT @@GLOBAL.tx_isolation, @@tx_isolation, @@session.tx_isolation;
+-----------------------+-----------------+------------------------+
| @@GLOBAL.tx_isolation | @@tx_isolation  | @@session.tx_isolation |
+-----------------------+-----------------+------------------------+
| REPEATABLE-READ       | REPEATABLE-READ | REPEATABLE-READ        |
+-----------------------+-----------------+------------------------+
1 row in set (0.00 sec)

2 같이 보기

• 트랜잭션 격리성 수준
• Error: 1205 Lock wait timeout exceeded; try restarting transaction

3 참고

• https://dev.mysql.com/doc/refman/5.7/en/set-transaction.html
• https://stackoverflow.com/questions/9880555/how-to-set-innodb-in-mysql-to-the-snapshot-isolation-level
• http://dba.fyicenter.com/faq/mysql/Change-Transaction-Isolation-Level.html