MySQL AUTOCOMMIT 확인

MySQL AUTOCOMMIT 확인

방법 1: SELECT

명령어

SELECT @@AUTOCOMMIT;

실행예시 (AUTOCOMMIT 활성화됨, 보통 이것이 기본값)

mysql> SELECT @@AUTOCOMMIT;
+--------------+
| @@AUTOCOMMIT |
+--------------+
|            1 |
+--------------+
1 row in set (0.00 sec)

실행예시 (AUTOCOMMIT 비활성화됨)

mysql> SELECT @@AUTOCOMMIT;
+--------------+
| @@AUTOCOMMIT |
+--------------+
|            0 |
+--------------+
1 row in set (0.00 sec)

방법 2: SHOW

mysql> SHOW VARIABLES LIKE 'autocommit';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| autocommit    | ON    |
+---------------+-------+
1 row in set (0.01 sec)

같이 보기

• MySQL AUTOCOMMIT 설정
• MySQL 트랜잭션
• MySQL 환경변수

참고

• http://junho85.tistory.com/11