mysql抛出异常:
Packet for query is too large (11600563 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable
解决方法:
1、查看参数值:
mysql> show VARIABLES like '%max_allowed_packet%';
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| max_allowed_packet | 1048576 |
| slave_max_allowed_packet | 1073741824 |
+--------------------------+------------+
说明:
1*1024*1024 = 1048576 =1M
2、修改参数值:
windows下 my.ini,linux下my.cnf,在[mysqld]下添加
max_allowed_packet = 524288000
说明:
500*1024*1024 =524288000=500M
修改完成之后要重启mysql