USERHOST

指示账户连接失败尝试的用户/主机组合，格式为 'user_name'@'host_name'。The user/host combination indicating an account that has failed connection attempts, in 'user_name'@'host_name' format.

FAILED_ATTEMPTS

USERHOST 值的当前连续连接失败次数。此计数包括所有失败的尝试，无论是否有延迟。服务器对其响应添加延迟的尝试次数为 FAILED_ATTEMPTS 值与 connection_control_failed_connections_threshold 系统变量值之间的差。The current number of consecutive failed connection attempts for the USERHOST value. This counts all failed attempts, regardless of whether they were delayed. The number of attempts for which the server added a delay to its response is the difference between the FAILED_ATTEMPTS value and the connection_control_failed_connections_threshold system variable value.

必须激活 CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS 插件才能使此表可用，并且必须激活 CONNECTION_CONTROL 插件，否则表内容将始终为空。参见 第 8.4.2 节，“连接控制插件”。The CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS plugin must be activated for this table to be available, and the CONNECTION_CONTROL plugin must be activated or the table contents are always empty. See Section 8.4.2, “Connection Control Plugins”.

该表仅包含那些连续失败的连接尝试至少一次且随后没有成功连接的帐户。当帐户成功连接时，其失败连接计数将重置为零，服务器会删除与该帐户对应的任何行。The table contains rows only for accounts that have had one or more consecutive failed connection attempts without a subsequent successful attempt. When an account connects successfully, its failed-connection count is reset to zero and the server removes any row corresponding to the account.

在运行时为connection_control_failed_connections_threshold系统变量分配值会将所有累积的失败连接计数器重置为零，这会导致表变为空。Assigning a value to the connection_control_failed_connections_threshold system variable at runtime resets all accumulated failed-connection counters to zero, which causes the table to become empty.