"MySQL tx isolation"의 두 판 사이의 차이

2017년 10월 1일 (일) 16:38 기준 최신판

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 같이 보기[ | ]

3 참고[ | ]

@@ 1번째 줄: / 1번째 줄: @@
+{{DISPLAYTITLE:MySQL tx_isolation}}
 ==개요==
+;transaction-isolation
 ;tx_isolation
+<source lang='console'>
+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        |
++-----------------------+-----------------+------------------------+
+row in set (0.00 sec)
+</source>
+==같이 보기==
+* [[트랜잭션 격리성 수준]]
+* [[Error: 1205 Lock wait timeout exceeded; try restarting transaction]]
 ==참고==
-* https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html#isolevel_read-uncommitted
 * 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