当前位置: 代码迷 >> 综合 >> nested exception is com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1109 1024
  详细解决方案

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

热度:29   发布时间:2023-12-18 14:48:57.0

登录mysql   

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;

    

  相关解决方案