参考:https://blog.csdn.net/ivory_town1/article/details/77702357
1.修改参数配置文件
vi /etc/my.cnf
[mysqld]
wait_timeout = 28800
interactive_timeout = 28800
#增加以上两列即可,因为官方文档要求修改此参数必须同时修改interactive_timeout
2.重启数据库
Service mysql restart
3.查看数据库参数是否修改成功
Show variables like ‘wait_timeout’;
https://blog.51cto.com/u_16175434/6742580
mysql5.7大量sleep进程常规处理方式及配置示例 https://www.jb51.net/database/295665m0c.htm
- wait_timeout timeout mysql5 mysql waitwait_timeout timeout mysql5 mysql wait_timeout timeout interactive_timeout wait_timeout interactive wait_timeout参数timeout global occurred timeout waiting object resthighlevelclient listener timeout waiting mysql5 mysql5 mysql centos7 centos mysql5 mysql docker mysql5 mysql