mysql 超时时间

 小结：

1、mysql服务端主动关闭链接的秒数；

 

MySQL :: MySQL 8.0 Reference Manual :: 5.1.8 Server System Variables https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_interactive_timeout

 

interactive_timeout

Property	Value
Command-Line Format	--interactive-timeout=#
System Variable	interactive_timeout
Scope	Global, Session
Dynamic	Yes
SET_VAR Hint Applies	No
Type	Integer
Default Value	28800
Minimum Value	1

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 theCLIENT_INTERACTIVE option to mysql_real_connect(). See also wait_timeout.

 

wait_timeout

Property	Value
Command-Line Format	--wait-timeout=#
System Variable	wait_timeout
Scope	Global, Session
Dynamic	Yes
SET_VAR Hint Applies	No
Type	Integer
Default Value	28800
Minimum Value	1
Maximum Value (Other)	31536000
Maximum Value (Windows)	2147483

 

The number of seconds the server waits for activity on a noninteractive connection before closing it.

On thread startup, the session wait_timeout value is initialized from the global wait_timeout value or from the global interactive_timeout value, depending on the type of client (as defined by the CLIENT_INTERACTIVE connect option to mysql_real_connect()). See also interactive_timeout.

 

 

 

案例：

 show GLOBAL VARIABLES  like '%timeout%';

Variable_name Value
connect_timeout 10
delayed_insert_timeout 300
failover_resend_timeout
have_statement_timeout YES
innodb_flush_log_at_timeout 1
innodb_lock_wait_timeout 50
innodb_rollback_on_timeout OFF
interactive_timeout 7200
lock_wait_timeout 31536000
net_read_timeout 30
net_write_timeout 60
rocksdb_io_write_timeout 0
rocksdb_lock_wait_timeout 1
rpl_semi_sync_master_timeout 1000
rpl_semi_sync_slave_kill_conn_timeout 5
rpl_stop_slave_timeout 31536000
slave_net_timeout 60
thread_pool_idle_timeout 60
tokudb_last_lock_timeout
tokudb_lock_timeout 4000
tokudb_lock_timeout_debug 1
wait_timeout 86400

 

版本

 show GLOBAL VARIABLES  like '%version%';

Variable_name Value
innodb_version 5.6.16
protocol_version 10
slave_type_conversions
tls_version TLSv1,TLSv1.1,TLSv1.2
tokudb_version 7.5.6
version 5.6.16-log
version_comment Source distribution
version_compile_compiler GNU
version_compile_compiler_major 4
version_compile_compiler_minor 8
version_compile_machine x86_64
version_compile_os Linux