备注:本人遇到并处理的方式
1.问题
Communications link failure The last packet successfully received from the server was 10,020 milliseconds ago. The last packet sent successfully to the server was 10,020 milliseconds ago.
从服务器成功接收到的最后一个数据包是10020毫秒以前。最后一个成功发送到服务器的数据包是10020毫秒前。
Communications link failure The last packet successfully received from the server was 10,020 milliseconds ago. The last packet sent successfully to the server was 10,020 milliseconds ago.
2.处理
1.首先查看当前数据库全局wait_timeout的时间
show global variables like '%wait_timeout%';
2.设置
将wait_timeout 和interactive_timeout 设置的大一点。默认是8小时(28800)。
set global wait_timeout=604800;
set global interactive_timeout=604800;
或者修改配置文件
maxWait: 180000
timeBetweenEvictionRunsMillis: 180000
minEvictableIdleTimeMillis: 300000
3.重启数据库 会失效
重启数据库:service mysql restart