Skip to content
Percona Software for MySQL Documentation

For help, click the link below to get free database assistance or contact our experts for personalized support.

Get help from Percona

Misc. Performance Schema tables

This page lists the performance_schema tables added to standard MySQL by Percona Server for MySQL that don’t exist elsewhere in the documentation.

Performance schema tables

performance_schema.account_failed_login_lock_status

The new performance_schema.account_failed_login_lock_status table is implemented in Percona Server for MySQL 8.0.44-35 and exposes information about temporary account locking from MySQL internal Access Control List (ACL) cache.

This table is read-only, and global, per-database or per-table SELECT privilege on this table are required from users who want to access the table contents.

Note

If an account is locked using the CREATE USER or ALTER USER statements with the ACCOUNT LOCK clause, this status is not captured in this table. The server records the ACCOUNT LOCK state in the mysql.user table.

Column Name Data Type Description
USER CHAR(..) Identifies the user account described by the table row
HOST CHAR(..) Identifies the user account described by the table row
IS_TRACKING_ACTIVE enum('YES','NO') Indicates whether failed login tracking is enabled for the account
MAX_ATTEMPTS INTEGER Maximum number of failed login attempts allowed before account is locked (corresponds to FAILED_LOGIN_ATTEMPTS clause value in CREATE USER statement)
PASSWORD_LOCK_DAYS INTEGER Number of days for which account will be temporarily locked after exceeding the MAX_ATTEMPS limit. Set to -1 if account is locked forever (corresponds to PASSWORD_LOCK_TIME clause value in CREATE USER)
IS_LOCKED BOOLEAN Indicates if account is temporarily locked by failed login lock tracking. NULL if tracking is not enabled for account
REMAINING_ATTEMPTS INTEGER Number of failed login attempts remaining before account will be locked. NULL if tracking is not enabled for account
REMAINING_DAYS_LOCKED INTEGER Number of days for which account is locked due to failed login lock tracking. -1 means that account is locked “forever” (until server restart/FLUSH PRIVILEGES or specific account unlock). NULL if tracking is not enabled for account