Meanings of four MYSQL timeout parameters

The meaning of four timeout parameters in MYSQL 4 timeout is used to prevent a link from occupying the descriptor of a database for a long time. If there is a problem with the network, the descriptor is not released, thread blocking is a waste of resources. we need to take the initiative to "card" off the peer! Www.2cto.com first look at The explanation of the four timeouts in The mysql5.1 Manual: connect_timeout the number of seconds that The mysqld server waits for a connect packet before responding with Bad handshake. interactive_timeout The number of seconds the server waits for activity on an interactive connection before closing it. wait_timeout The number of seconds the server waits for activity on a noninteractive connection before closin G it. net_read_timeout The number of seconds to wait for more data from a connection before aborting the read. net_write_timeout The number of seconds to wait for a block to be written to a connection before aborting the write. it can be understood that connect_timeout works in the authenticate phase, interactive_timeout and wait_timeout work in the idle phase, and net_read_timeout and net_write_timeout work in the query phase.