mysql执行sql错误：[ERR] 2006 - Server has gone away。[ERR] 1153 - Got a packet bigger than ‘max_allowed_pa

[SQL] Query 111 start
[ERR] 2006 - Server has gone away
[ERR] 
[ERR] 1153 - Got a packet bigger than 'max_allowed_packet' bytes
[ERR] 
INSERT INTO `panel_group_extend_data` VALUES (......);
[SQL] Finished with error

当查询的结果集超过 max_allowed_packet 也会出现这样的报错。

show global variables like 'max_allowed_packet';

可以通过修改max_allowed_packed的配置参数来避免。

set global max_allowed_packet=1024*1024*16;

若仍报错，可将长度设置为10241024512;