Packet for query is too large解决办法

Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (5430881 > 4194304). You can change this value on the server by setting the max_allowed_packet’ variable.

场景：插入的数据大小超过max_allowed_packet指定的值

解决：修改my.cnf中的配置来解决

注意：应该编辑/etc/my.cnf来修改，直接执行命令行会报错。

which mysql

/usr/bin/mysql --verbose --help | grep -A 1 'Default options'

# 修改my.cnf
max_allowed_packet=1024M

sudo systemctl restart mysqld