mysql interactive_MySQL连接超时相关的两个参数interactive_timeout和wait_timeout的区别和解释...

先看看官方文档对于这两个参数的定义

interactive_timeout

默认是28800，单位秒，即8个小时

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.

wait_timeout

默认同样是28800s

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.

interactive_timeout针对交互式连接，wait_timeout针对非交互式连接。所谓的交互式连接，即在mysql_real_connect()函数中使用了CLIENT_INTERACTIVE选项。

说得直白一点，通过mysql客户端连接数据库是交互式连接，通过jdbc连接数据库是非交互式连接。

interactive_timeout：交互式连接超时时间(mysql工具、mysqldump等)

wait_timeout：非交互式连接超时时间，默认的连接mysql api程序,jdbc连接数据库等

在连接启动的时候，根据连接的类型，来确认会话变量wait_timeout的值是继承于全局变量wait_timeout，还是interactive_timeout。

如何设置和查看:

mysql> set global interactive_timeout=1800;

Query OK, 0 rows affected (0.00 sec)

mysql> set global wait_timeout=1800;

Query OK, 0 rows affected (0.00 sec)

mysql> show global variables like 'interactive_timeout';

+---------------------+-------+

| Variable_name       | Value |

+---------------------+-------+

| interactive_timeout | 1800  |

+---------------------+-------+

1 row in set (0.00 sec)

mysql> show global variables like 'wait_timeout';

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| wait_timeout  | 1800  |

+---------------+-------+

1 row in set (0.00 sec)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15498/viewspace-2133456/，如需转载，请注明出处，否则将追究法律责任。