Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-column-privileges-table.html
The COLUMN_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the table containing the column belongs. TABLE_SCHEMA ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-connection-control-failed-login-attempts-table.html
This table provides information about the current number of consecutive failed connection attempts per account (user/host combination). CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS has these columns: USERHOST The user/host combination indicating an ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-connection-control-table-reference.html
Table 28.8 INFORMATION_SCHEMA Connection Control Tables Table Name Description CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Current number of consecutive failed connection attempts per account .
https://dev.mysql.com/doc/refman/8.4/en/information-schema-firewall-table-reference.html
Table 28.9 INFORMATION_SCHEMA Firewall Tables Table Name Description Deprecated MYSQL_FIREWALL_USERS Firewall in-memory data for account profiles Yes MYSQL_FIREWALL_WHITELIST Firewall in-memory data for account profile allowlists Yes .
https://dev.mysql.com/doc/refman/8.4/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 28.2 INFORMATION_SCHEMA General Tables Table Name Description ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable users or ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-pool-stats-table.html
NOT_YOUNG_MAKE_PER_THOUSAND_GETS The number of pages not made young per thousand gets. The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ENGINE INNODB STATUS output. Much of the same information ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cached-indexes-table.html
The INNODB_CACHED_INDEXES table reports the number of index pages cached in the InnoDB buffer pool for each index. For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. Index ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-datafiles-table.html
The INNODB_DATAFILES table provides data file path information for InnoDB file-per-table and general tablespaces. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. Note The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-fields-table.html
The INNODB_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_FIELDS table has these ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-foreign-cols-table.html
The INNODB_FOREIGN_COLS table provides status information about InnoDB foreign key columns. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_FOREIGN_COLS table has ...