Packet for query is too large (4,544,730 > 4,194,304). You can change this value on the server by setting the 'max_allowed_packet' variable.

2023-04-25,,

修改 my.ini 加上 max_allowed_packet =67108864
67108864=64M
默认大小4194304  也就是4M
修改完成之后要重启mysql服务,如果通过命令行修改就不用重启mysql服务。
命令修改:
设置为500M
mysql> set global max_allowed_packet = 500*1024*1024;

查看mysql的max_allowed_packet大小,运行
show VARIABLES like '%max_allowed_packet%';

可能不会立即生效,可以关闭命令行重新打开

Packet for query is too large (4,544,730 > 4,194,304). You can change this value on the server by setting the 'max_allowed_packet' variable.的相关教程结束。

《Packet for query is too large (4,544,730 > 4,194,304). You can change this value on the server by setting the 'max_allowed_packet' variable..doc》

下载本文的Word格式文档,以方便收藏与打印。