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





 

©️2020 CSDN 皮肤主题: 大白 设计师: CSDN官方博客 返回首页
实付0元
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值