MySQL 连接超时,不活动

问题描述:

我安装了 MySQL 服务器,我希望它停止丢弃不活动的连接.我需要调整哪个选项?MySQL 服务器安装在 Windows 机器上.

I have MySQL server installed and I would like it to stop dropping inactive connections. Which option do I need to adjust? The MySQL server is installed on a Windows machine.

谢谢

您正在寻找 MySQL wait_timeout 变量.

You are looking for the MySQL wait_timeout variable.

SET @@GLOBAL.wait_timeout=2147483