Mysql wait_timeout interactive_timeout变量

wait_timeout

Mysql活动链接的时间限制，当进行长连接时，该值应该尽可能的大 

The number of seconds the server waits for activity on a noninteractive connection before closing it. This timeout applies only to TCP/IP and Unix socket file connections, not to connections made via named pipes, or shared memory.

Command-Line Format	--wait_timeout=#
Config-File Format	wait_timeout
Option Sets Variable	Yes, wait_timeout
Variable Name	wait_timeout
Variable Scope	Both
Dynamic Variable	Yes
	Permitted Values
	Type	numeric
	Default	28800
	Range	1-31536000
	Permitted Values
	Type (windows)	numeric
	Default	28800
	Range	1-2147483

interactive_timeout

The number of seconds the server waits for activity on an interactive connection before closing it. An interactive client is defined as a client that uses the CLIENT_INTERACTIVE option to mysql_real_connect(). See also wait_timeout.





Command-Line Format	--interactive_timeout=#
Config-File Format	interactive_timeout
Option Sets Variable	Yes, interactive_timeout
Variable Name	interactive_timeout
Variable Scope	Both
Dynamic Variable	Yes
	Permitted Values
	Type	numeric
	Default	28800
	Min Value	1