Packet for query is too large (30697 > 1024)解决方案

报错如下：

com.mysql.jdbc.PacketTooBigException: Packet for query is too large (30697 > 1024).

You can change this value on the server by setting the max_allowed_packet' variable.

MySQL根据配置文件会限制server接受的数据包大小，

有时候大的插入和更新会被max_allowed_packet 参数限制掉，导致失败，提示“Packet for query is too large (30697 > 1024)”

查看目前配置:

show VARIABLES like '%max_allowed_packet%'; 默认为1M

改为更大的值：

set global max_allowed_packet = 2*1024*1024*10;

Mysql重新启动后，再重新进入MySQL查询即发现已生效。如果不重新启动Mysql，进去查询则该值不会变