MySQL出现 [ERR] 2013 - “Lost connection to MySQL server during query”解决方案

• 配置MySQL允许的最大数据包大小‘max_allowed_packet'

--全局修改max_allowed_packet 为500M
set global max_allowed_packet=1024*1024*500;
--查看修改后的值
show global variables like 'max_allowed_packet' ;

• 全局修改超时参数

--全局修改超时参数
set global wait_timeout = 60000;
set global net_read_timeout = 120; 
set global net_write_timeout = 900;

--查看超时参数
show variables like '%timeout%';