mysql wait_timeout:
注:
wait_timeout默认为28800,timeout过大会导致Sleep进程过多,从而导致服务器CPU很高
一般Sleep过多会占用较高CPU等资源
# mysql -u root -p'xxxx' -e "show processlist;" | grep Sleep | wc -l
查看mysql的wait_timeout时长设置:
# mysql -u root -p'xxxx' -e "show global variables like 'wait_timeout';"
设置mysql的wait_timeout时长:
> set global wait_timeout=300;
可写到/etc/my.cnf
# vi /etc/my.cnf
wait_timeout=300
:wq
转载于:https://blog.51cto.com/yangzhiming/1910636