by 知识混子
Posted on 星期三 2018年12月26日 at 02:37下午 in IT技术
问题：MySQL一段时间不操作则服务停掉。
参考解决方法：https://124654439.iteye.com/blog/2174953
注意该文章的后半部分，否则就白看了。关键点是修改参数要带 global
以root身份连接登录进mysql
mysql> show global variables like 'wait_timeout';
mysql> set global interactive_timeout= 31536000;
mysql> set global wait_timeout=31536000;
以观后效
Tags: mysql
You're viewing a weblog entry titled MySQL一段时间不操作则服务停掉. If you like this entry you might want to:
Bookmark it |
Digg it |
Slashdot it |
See who links to it
|
This is just one entry in the weblog 知识混子的博客. Why don't you visit the main page of the weblog?