mysql> SELECT @@max_allowed_packet;

+----------------------+

| @@max_allowed_packet |

+----------------------+

|              1048576 |

+----------------------+

1 row in set



vi /etc/my.cnf

[mysqld]
max_allowed_packet=16M

이 항목을 추가 해준다.


mysql> SELECT @@max_allowed_packet;
+----------------------+
| @@max_allowed_packet |
+----------------------+
|             16777216 |
+----------------------+
1 row in set







Posted by [czar]
,