Know/DATABASE

ERROR 2006 : MySQL server has gone away

Marine™ 2005. 6. 21. 15:14
반응형
ERROR 2006: MySQL server has gone away

자료를 찾아보면,

이 에러는 MySQL 서버와 클라이언트 사이에 통신이 제대로 안 될때 발생한다고 한다.

wait_timeout을 다시 설정하고,
interactive_timeout을 다시 설정해도,
저 에러코드는 계속 나올 경우는..
max_allowed_packet 의 value를 늘려주길.

ex)
max_allowed_packet=4294967295
wait_timeout=300000

아래는 mysql.org에서 발췌.

You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld receives a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by setting the server's max_allowed_packet variable, which has a default value of 1MB. You may also need to increase the maximum packet size on the client end. More information on setting the packet size is given in Section A.2.9, “Packet too large”.


반응형

'Know > DATABASE' 카테고리의 다른 글

DB2 JDBC TYPE  (0) 2006.07.13
JDBC FAILOVER 구현예제  (0) 2006.07.12
rollup  (0) 2006.02.15
IBM WebSphere 5.0 데이타베이스 연결 설정법  (0) 2005.06.23
[MySQL] time out(wait_timeout) 계산과 설정  (0) 2005.06.21