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
| 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.
| 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
