MySQL 8.0 Reference Manual
MySQL 8.0 Release Notes
The following table summarizes all available
INFORMATION_SCHEMA tables. For greater detail,
see the individual table descriptions.
Table 3.1 INFORMATION_SCHEMA Tables
| Table Name | Description | Introduced | Deprecated |
|---|---|---|---|
ADMINISTRABLE_ROLE_AUTHORIZATIONS |
Grantable users or roles for current user or role | 8.0.19 | |
APPLICABLE_ROLES |
Applicable roles for current user | 8.0.19 | |
CHARACTER_SETS |
Available character sets | ||
CHECK_CONSTRAINTS |
Table and column CHECK constraints | 8.0.16 | |
COLLATION_CHARACTER_SET_APPLICABILITY |
Character set applicable to each collation | ||
COLLATIONS |
Collations for each character set | ||
COLUMN_PRIVILEGES |
Privileges defined on columns | ||
COLUMN_STATISTICS |
Histogram statistics for column values | ||
COLUMNS |
Columns in each table | ||
COLUMNS_EXTENSIONS |
Column attributes for primary and secondary storage engines | 8.0.21 | |
CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS |
Current number of consecutive failed connection attempts per account | ||
ENABLED_ROLES |
Roles enabled within current session | 8.0.19 | |
ENGINES |
Storage engine properties | ||
EVENTS |
Event Manager events | ||
FILES |
Files that store tablespace data | ||
INNODB_BUFFER_PAGE |
Pages in InnoDB buffer pool | ||
INNODB_BUFFER_PAGE_LRU |
LRU ordering of pages in InnoDB buffer pool | ||
INNODB_BUFFER_POOL_STATS |
InnoDB buffer pool statistics | ||
INNODB_CACHED_INDEXES |
Number of index pages cached per index in InnoDB buffer pool | ||
INNODB_CMP |
Status for operations related to compressed InnoDB tables | ||
INNODB_CMP_PER_INDEX |
Status for operations related to compressed InnoDB tables and indexes | ||
INNODB_CMP_PER_INDEX_RESET |
Status for operations related to compressed InnoDB tables and indexes | ||
INNODB_CMP_RESET |
Status for operations related to compressed InnoDB tables | ||
INNODB_CMPMEM |
Status for compressed pages within InnoDB buffer pool | ||
INNODB_CMPMEM_RESET |
Status for compressed pages within InnoDB buffer pool | ||
INNODB_COLUMNS |
Columns in each InnoDB table | ||
INNODB_DATAFILES |
Data file path information for InnoDB file-per-table and general tablespaces | ||
INNODB_FIELDS |
Key columns of InnoDB indexes | ||
INNODB_FOREIGN |
InnoDB foreign-key metadata | ||
INNODB_FOREIGN_COLS |
InnoDB foreign-key column status information | ||
INNODB_FT_BEING_DELETED |
Snapshot of INNODB_FT_DELETED table | ||
INNODB_FT_CONFIG |
Metadata for InnoDB table FULLTEXT index and associated processing | ||
INNODB_FT_DEFAULT_STOPWORD |
Default list of stopwords for InnoDB FULLTEXT indexes | ||
INNODB_FT_DELETED |
Rows deleted from InnoDB table FULLTEXT index | ||
INNODB_FT_INDEX_CACHE |
Token information for newly inserted rows in InnoDB FULLTEXT index | ||
INNODB_FT_INDEX_TABLE |
Inverted index information for processing text searches against InnoDB table FULLTEXT index | ||
INNODB_INDEXES |
InnoDB index metadata | ||
INNODB_METRICS |
InnoDB performance information | ||
INNODB_SESSION_TEMP_TABLESPACES |
Session temporary-tablespace metadata | 8.0.13 | |
INNODB_TABLES |
InnoDB table metadata | ||
INNODB_TABLESPACES |
InnoDB file-per-table, general, and undo tablespace metadata | ||
INNODB_TABLESPACES_BRIEF |
Brief file-per-table, general, undo, and system tablespace metadata | ||
INNODB_TABLESTATS |
InnoDB table low-level status information | ||
INNODB_TEMP_TABLE_INFO |
Information about active user-created InnoDB temporary tables | ||
INNODB_TRX |
Active InnoDB transaction information | ||
INNODB_VIRTUAL |
InnoDB virtual generated column metadata | ||
KEY_COLUMN_USAGE |
Which key columns have constraints | ||
KEYWORDS |
MySQL keywords | ||
MYSQL_FIREWALL_USERS |
Firewall in-memory data for account profiles | 8.0.26 | |
MYSQL_FIREWALL_WHITELIST |
Firewall in-memory data for account profile allowlists | 8.0.26 | |
ndb_transid_mysql_connection_map |
NDB transaction information | ||
OPTIMIZER_TRACE |
Information produced by optimizer trace activity | ||
PARAMETERS |
Stored routine parameters and stored function return values | ||
PARTITIONS |
Table partition information | ||
PLUGINS |
Plugin information | ||
PROCESSLIST |
Information about currently executing threads | ||
PROFILING |
Statement profiling information | ||
REFERENTIAL_CONSTRAINTS |
Foreign key information | ||
RESOURCE_GROUPS |
Resource group information | ||
ROLE_COLUMN_GRANTS |
Column privileges for roles available to or granted by currently enabled roles | 8.0.19 | |
ROLE_ROUTINE_GRANTS |
Routine privileges for roles available to or granted by currently enabled roles | 8.0.19 | |
ROLE_TABLE_GRANTS |
Table privileges for roles available to or granted by currently enabled roles | 8.0.19 | |
ROUTINES |
Stored routine information | ||
SCHEMA_PRIVILEGES |
Privileges defined on schemas | ||
SCHEMATA |
Schema information | ||
SCHEMATA_EXTENSIONS |
Schema options | 8.0.22 | |
ST_GEOMETRY_COLUMNS |
Columns in each table that store spatial data | ||
ST_SPATIAL_REFERENCE_SYSTEMS |
Available spatial reference systems | ||
ST_UNITS_OF_MEASURE |
Acceptable units for ST_Distance() | 8.0.14 | |
STATISTICS |
Table index statistics | ||
TABLE_CONSTRAINTS |
Which tables have constraints | ||
TABLE_CONSTRAINTS_EXTENSIONS |
Table constraint attributes for primary and secondary storage engines | 8.0.21 | |
TABLE_PRIVILEGES |
Privileges defined on tables | ||
TABLES |
Table information | ||
TABLES_EXTENSIONS |
Table attributes for primary and secondary storage engines | 8.0.21 | |
TABLESPACES |
Tablespace information | 8.0.22 | |
TABLESPACES_EXTENSIONS |
Tablespace attributes for primary storage engines | 8.0.21 | |
TP_THREAD_GROUP_STATE |
Thread pool thread group states | ||
TP_THREAD_GROUP_STATS |
Thread pool thread group statistics | ||
TP_THREAD_STATE |
Thread pool thread information | ||
TRIGGERS |
Trigger information | ||
USER_ATTRIBUTES |
User comments and attributes | 8.0.21 | |
USER_PRIVILEGES |
Privileges defined globally per user | ||
VIEW_ROUTINE_USAGE |
Stored functions used in views | 8.0.13 | |
VIEW_TABLE_USAGE |
Tables and views used in views | 8.0.13 | |
VIEWS |
View information |