This section describes the system and status variables that the 本节介绍CONNECTION_CONTROL
plugin provides to enable its operation to be configured and monitored.CONNECTION_CONTROL
插件提供的系统和状态变量,以配置和监视其操作。
If the 如果安装了CONNECTION_CONTROL
plugin is installed, it exposes these system variables:CONNECTION_CONTROL
插件,它将公开以下系统变量:
connection_control_failed_connections_threshold
--connection-control-failed-connections-threshold=# |
|
connection_control_failed_connections_threshold |
|
Global | |
Yes | |
SET_VAR | No |
Integer | |
3 |
|
0 |
|
2147483647 |
The number of consecutive failed connection attempts permitted to accounts before the server adds a delay for subsequent connection attempts:在服务器为后续连接尝试添加延迟之前,允许帐户连续失败的连接尝试次数:
If the variable has a nonzero value 如果变量具有非零值N
, the server adds a delay beginning with consecutive failed attempt N
+1. N
,则服务器将从连续失败的尝试N+1
开始添加延迟。If an account has reached the point where connection responses are delayed, a delay also occurs for the next subsequent successful connection.如果帐户已达到连接响应延迟的点,则下一个成功连接也会出现延迟。
Setting this variable to zero disables failed-connection counting. In this case, the server never adds delays.将此变量设置为零将禁用失败连接计数。在这种情况下,服务器永远不会增加延迟。
For information about how 有关connection_control_failed_connections_threshold
interacts with other connection-control system and status variables, see Section 6.4.2.1, “Connection-Control Plugin Installation”.connection_control_failed_connections_threshold
如何与其他连接控制系统和状态变量交互的信息,请参阅第6.4.2.1节,“连接控制插件安装”。
connection_control_max_connection_delay
--connection-control-max-connection-delay=# |
|
connection_control_max_connection_delay |
|
Global | |
Yes | |
SET_VAR | No |
Integer | |
2147483647 |
|
1000 |
|
2147483647 |
|
milliseconds |
The maximum delay in milliseconds for server response to failed connection attempts, if 如果connection_control_failed_connections_threshold
is greater than zero.connection_control_failed_connections_threshold
大于零,则服务器对连接尝试失败的响应的最大延迟(毫秒)。
For information about how 有关connection_control_max_connection_delay
interacts with other connection-control system and status variables, see Section 6.4.2.1, “Connection-Control Plugin Installation”.connection_control_max_connection_delay
如何与其他连接控制系统和状态变量交互的信息,请参阅第6.4.2.1节,“连接控制插件安装”。
connection_control_min_connection_delay
--connection-control-min-connection-delay=# |
|
connection_control_min_connection_delay |
|
Global | |
Yes | |
SET_VAR | No |
Integer | |
1000 |
|
1000 |
|
2147483647 |
|
milliseconds |
The minimum delay in milliseconds for server response to failed connection attempts, if 如果connection_control_failed_connections_threshold
is greater than zero.connection_control_failed_connections_threshold
大于零,则服务器对连接尝试失败的响应的最小延迟(毫秒)。
For information about how 有关connection_control_min_connection_delay
interacts with other connection-control system and status variables, see Section 6.4.2.1, “Connection-Control Plugin Installation”.connection_control_min_connection_delay
如何与其他连接控制系统和状态变量交互的信息,请参阅第6.4.2.1节,“连接控制插件安装”。
If the 如果安装了CONNECTION_CONTROL
plugin is installed, it exposes this status variable:CONNECTION_CONTROL
插件,它将公开此状态变量:
Connection_control_delay_generated
The number of times the server added a delay to its response to a failed connection attempt. 服务器对连接尝试失败的响应增加延迟的次数。This does not count attempts that occur before reaching the threshold defined by the 这不计算在达到connection_control_failed_connections_threshold
system variable.connection_control_failed_connections_threshold
系统变量定义的阈值之前发生的尝试。
This variable provides a simple counter. 此变量提供了一个简单的计数器。For more detailed connection-control monitoring information, examine the 有关更详细的连接控制监视信息,请检查INFORMATION_SCHEMA
CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
table; see Section 26.6.2, “The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table”.INFORMATION_SCHEMA
CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
表;请参阅第26.6.2节,“信息_原理图连接_CONTROL_FAILED_LOGIN_ATTEMPTS表”。
Assigning a value to 在运行时为connection_control_failed_connections_threshold
at runtime resets Connection_control_delay_generated
to zero.connection_control_failed_connections_threshold
赋值会将connection_control_delay_generated
重置为零。