Mysql报错:Packet for query is too large (1121604 > 1048576).You can change this value on the server by setting the max_allowed_packet variable
看错误信息,发现1048576个字节,正好是1*1024*1024byte,也就是1Mb。
这正是mysql默认的max_allowed_packet值。
-
使用sql语句:
show VARIABLES like '%max_allowed_packet%'
可以查询到相应的max_allowed_packet值 -
需要在/etc/my.cnf配置文件中mysqld字段下进行设置:
max_allowed_packet = 20M -
重启mysql服务:
service mysqld restart
浙公网安备 33010602011771号