MySql Server 입력 packet Size (max_allowed_packet 설정)

http://blackbull.tistory.com/12

my.ini

my.cnf

max_allowed_packet = 필요량M  으로 변경

mysql client 의 디폴트가 16M 이니까 서버도 16M으로 하면 될까?

http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html

By default configuration
------------------------------------------------------------
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
------------------------------------------------------------

change "max_allowed_packet = 1M" to "max_allowed_packet = 32M"