Got a packet bigger than 'max_allowed_packet' bytes
0.mysql根據配置文件中max_allowed_packet的值限制server接受的數據包大小
1.查看max_allowed_packet
show VARIABLES like '%max_allowed_packet%';
以上說明目前的配置是:1M
2.修改配置
2.1臨時修改
set global max_allowed_packet=134217728;
set global max_allowed_packet=134217728;
修改為 #128M
注:需重新mysql后查看
2.2永久修改
my.cnf中max_allowed_packet = 128M鳖宾,重啟mysql