빅

MySQL server has gone away 에러

· 2012-05-08 (화) 06:53:22 · 3411
 
대용량 쿼리문 실행시 MySQL server has gone away  와 같은 에러메시지가 발생한다.

 아래 명령어로 설정된 값 확인해 보기
 -> show variables like 'max_allowed_packet';  

 SET GLOBAL max_allowed_packet=xxxxxxxx;      byte 단위이다.

 

저는 192 M로 변경해 보았습니다.

기존 16M 였습니다.

 

mysql> show variables like 'max_allowed_packet';
+--------------------+----------+
| Variable_name      | Value    |
+--------------------+----------+
| max_allowed_packet | 16777216 | 
+--------------------+----------+

mysql> set GLOBAL max_allowed_packet=201326592;
Query OK, 0 rows affected (0.00 sec)

정상으로 적용되었네요.

다시 확인 해 볼까요?

mysql> show variables like 'max_allowed_packet';
+--------------------+----------+
| Variable_name      | Value    |
+--------------------+----------+
| max_allowed_packet | 16777216 | 
+--------------------+----------+

이론...기존값으로 나오네요.

 

mysql > quit 했다가 다시 접속해 보니,

 

mysql> show variables like 'max_allowed_packet';
+--------------------+-----------+
| Variable_name      | Value     |
+--------------------+-----------+
| max_allowed_packet | 201326592 | 
+--------------------+-----------+
1 row in set (0.00 sec)

댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,187건
+
제목 글쓴이 날짜 조회
12-04-24 조회 2,663
12-04-24 조회 2,726
12-04-24 조회 3,880
12-04-24 조회 3,021
12-04-24 조회 3,369
12-04-24 조회 2,761
12-04-24 조회 3,277
12-04-24 조회 2,806
12-04-24 조회 2,786
12-04-24 조회 2,968
12-04-24 조회 4,656
12-04-23 조회 3,108
12-04-23 조회 3,919
12-04-23 조회 2,728
12-04-23 조회 2,738
12-04-23 조회 3,010
12-04-23 조회 2,653
12-04-23 조회 3,691
12-04-23 조회 2,578
12-04-23 조회 2,653
12-04-23 조회 3,006
12-04-23 조회 2,813
12-04-23 조회 2,661
12-04-23 조회 2,858
12-04-23 조회 2,857
12-04-23 조회 2,617
12-04-23 조회 4,609
12-04-23 조회 3,637
12-04-23 조회 3,506
12-04-22 조회 2,638
12-04-22 조회 2,597
12-04-22 조회 2,679
12-04-22 조회 2,893
12-04-22 조회 2,695
12-04-22 조회 3,306
12-04-22 조회 3,347
12-04-22 조회 2,941
12-04-21 조회 3,198
12-04-21 조회 4,141
12-04-21 조회 4,578
12-04-21 조회 7,906
12-04-21 조회 2,720
12-04-21 조회 3,118
12-04-21 조회 2,618
12-04-21 조회 2,856
12-04-20 조회 3,658
12-04-20 조회 3,163
12-04-20 조회 2,833
12-04-20 조회 2,919
12-04-20 조회 2,715
12-04-20 조회 2,839
12-04-20 조회 3,970
12-04-20 조회 4,186
12-04-20 조회 3,044
12-04-20 조회 3,297
12-04-20 조회 4,399
12-04-20 조회 3,337
12-04-19 조회 3,391
12-04-19 조회 3,030
12-04-18 조회 4,459
12-04-18 조회 2,922
12-04-18 조회 3,159
12-04-17 조회 3,421
12-04-17 조회 3,594
12-04-17 조회 5,190
12-04-17 조회 5,491
12-04-17 조회 2,922
12-04-17 조회 3,424
12-04-16 조회 2,897
12-04-16 조회 3,618
12-04-16 조회 3,319
12-04-16 조회 3,202
12-04-16 조회 3,618
12-04-16 조회 2,847
12-04-16 조회 4,428
12-04-15 조회 4,005
12-04-14 조회 3,692
12-04-14 조회 3,085
12-04-14 조회 3,749
12-04-14 조회 3,800
12-04-13 조회 3,437
12-04-13 조회 4,632
12-04-13 조회 3,231
12-04-13 조회 2,959
12-04-13 조회 3,176
12-04-13 조회 6,254
12-04-12 조회 4,872
12-04-12 조회 3,405
12-04-11 조회 3,632
12-04-10 조회 5,115
12-04-10 조회 4,064
12-04-10 조회 3,179
12-04-09 조회 3,221
12-04-09 조회 4,793
12-04-09 조회 3,148
12-04-08 조회 3,484
12-04-07 조회 2,811
12-04-06 조회 2,962
12-04-06 조회 3,712
12-04-06 조회 5,492