`wait_timeout` is a system variable in MySQL that sets the amount of time that MySQL waits for activity on a non-interactive connection before closing it.
If you want to check the current value of `wait_timeout`, use the following command:
“`sql
SHOW VARIABLES LIKE ‘wait_timeout’;
“`
To change the `wait_timeout` value, you can use the following command:
“`sql
SET GLOBAL wait_timeout = your_desired_value;
“`
Replace ‘your_desired_value’ with the number of seconds you want to set.
Remember, this configuration should be done carefully as setting a high timeout value may consume server resources unnecessarily, while setting a low value may interrupt long-running processes.
© 版权声明
文章版权归作者所有,未经允许请勿转载。
暂无评论内容