Let’s have deeper look at how to Adjust wait_timeout MySQL. At Bobcares, with help of our Server support services, we respond to all your queries, no matter how minor.

wait_timeout: This is said to be the number of seconds the server waits for activity on a noninteractive connection before closing it.

connect_timeout: The number of seconds that the mysqld server waits to connect the packet before responding with a Bad handshake.

Changing MySQL wait_timeout variable

• You can set the variable wait_timeout, for a session or globally.

• For a session, if we set the wait_timeout variable then it will valid only for a particular session. However, if we set the wait_timeout variable globally it will valid for all the sessions.

To run these commands. Initially, we need to log in to the MySql server.

We can refer to the current values of wait_timeout variable using the below commands.

SHOW SESSION VARIABLES LIKE “%wait_timeout%”; or SHOW SESSION VARIABLES LIKE “wait_timeout”;

• The default wait_timeout value is 28800 seconds.

To set this timeout for a session, follow the below command.

SET session wait_timeout=300;

If you need to change the wait_timeout global value, then follow below steps:

1. Open my.cnf file from path /etc/mysql directory.

2. Next, add the below value with the MySQL blog to my.cnf file.

wait_timeout=300
interactive_timeout = 300

3. Restart the MySQL server.

service mysql restart

4. Further you can see the wait_timeout variable has changed globally to 300.

After changing the global value, the wait_timeout value will be updated to 300.

Another method:

1. Open MySQL.

sudo service mysql start

2. Open the command window.

sudo mysql -u username -p

3. Change the timeout.

SET @@GLOBAL.interactive_timeout=31536000

4. Restart server.

sudo service mysql restart

The windows timeout default is 31536000. You can choose the time you prefer.  The way to follow the timeout is show global variables like 'wait_timeout'.

[Looking for a solution to another query? We are just a click away.]

Conclusion

To conclude, we have seen how to Adjust wait_timeout MySQL from this article. Discussed about wait_timeout and connect_timeout.