Home  >  Article  >  Database  >  mysql 长时间连接没操作,断开连接_MySQL

mysql 长时间连接没操作,断开连接_MySQL

WBOY
WBOYOriginal
2016-06-01 13:11:091886browse

mysql默认wait_timeout时间是8小时,查看方式:

mysql>show global variales like 'wait_timeout';

此期间没有任何操作的话,mysql会回收掉连接。

修改配置文件,linux下配置文件:/etc/my.cnf


Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn