What is the method for setting a timeout for MySQL connections?

2 years ago
Olivia Parker
1 minute

In MySQL, you can adjust the wait_timeout parameter to set the timeout period for connections. The wait_timeout parameter indicates the amount of time (in seconds) the server will wait before disconnecting if there is no activity on the connection. The default value is 28800 seconds (8 hours).

To modify the wait_timeout parameter, you can follow these steps:

  1. Login to the MySQL database server.
  2. Execute the following command to view the current value of the wait_timeout parameter:
SHOW VARIABLES LIKE 'wait_timeout';
  1. timeout for waiting
SET GLOBAL wait_timeout = 600; -- 将超时时间设置为10分钟
  1. the period of time before a timeout occurs
  2. configuration file for MySQL
  3. configuration file
  4. Under the section labeled “mysqld”
wait_timeout = 600
  1. Restart the MySQL server to apply the changes.
sudo service mysql restart

By following the steps above, you can set the timeout for MySQL connections to meet specific requirements.

bannerAds