How to modify wait_timeout in mysql

Mysql how to modify wait_timeout, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Mysql modifies wait_timeout

Mysql

Mysql > show global variables like 'wait_timeout'

Its default value is 8 hours.

When a connection of the mysql is idle for more than 8 hours, the mysql automatically disconnects the connection.

1. Modify configuration

Vi / etc/my.cnf

[mysqld]

Wait_timeout=10

# / etc/init.d/mysql restart

two。 Modify directly with the sql command line

Mysql > set global wait_timeout=10

Mysql > show global variables like 'wait_timeout'

Show variables like'% time%'

TimeBetweenEvictionRunsMillis = 20000

# dbcp checks connection every 2000 seconds

MinEvictableIdleTimeMillis = 28700

# disconnect the connection that is idle for more than 28700 seconds in each inspection

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.