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

原文地址:https://www.cnblogs.com/mrnx2004/p/10593922.html