nested exception is com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1109 > 1024

MySQL的一个系统参数:max_allowed_packet

>mysql -u root -p //root登录

1. 查看系统参数:show VARIABLES like '%max_allowed_packet%'

    

2. 设置系统参数:set global max_allowed_packet = 2*1024*1024*10;

    

  /etc/init.d/mysqld restart

原文地址:https://www.cnblogs.com/xx0405/p/5590088.html