PDF (US Ltr)
- 3.9Mb
PDF (A4)
- 3.9Mb
The following table shows all INFORMATION_SCHEMA tables available in MySQL Server. The table contains these columns:
Name: The item name.
Introduced: The version or versions in which the item was introduced. This column appears only if it applies to some item.
Deprecated: The version or versions in which the item was deprecated. This column appears only if it applies to some item.
Removed: The version or versions in which the item was removed. This column appears only if it applies to some item.
-
Whether the item is available in the corresponding MySQL Server series. The indicator links to the item description in the main reference manual if more information is available.
An item has a row in the table if it ever existed in any series shown in the table. The value displayed for a given series indicates item availability in that series:
Yes: The item is available in all production-ready General Availability (GA) versions. For a series that has not reached GA status, Yes indicates that the item is available in the most recently released pre-GA version.
Some: The item is available in some GA versions. This is the case if the item was introduced after the first GA version, or removed from some GA version.
Blank: The item is not available in any GA version. Either it does not exist in the series, or existed in pre-GA versions but was removed before the series reached GA status.
Table 4.1 INFORMATION_SCHEMA Table Reference
| Table Name | Introduced | Deprecated | Removed | 5.7 | 8.0 | 8.1 | 8.2 | 8.3 | 8.4 | 9.0 | 9.1 |
|---|---|---|---|---|---|---|---|---|---|---|---|
ADMINISTRABLE_ROLE_AUTHORIZATIONS |
8.0.19 | Some | Yes | Yes | Yes | Yes | Yes | Yes | |||
APPLICABLE_ROLES |
8.0.19 | Some | Yes | Yes | Yes | Yes | Yes | Yes | |||
CHARACTER_SETS |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
CHECK_CONSTRAINTS |
8.0.16 | Some | Yes | Yes | Yes | Yes | Yes | Yes | |||
COLLATION_CHARACTER_SET_APPLICABILITY |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
COLLATIONS |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
COLUMN_PRIVILEGES |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
COLUMN_STATISTICS |
8.0.2 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
COLUMNS |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
COLUMNS_EXTENSIONS |
8.0.21 | Some | Yes | Yes | Yes | Yes | Yes | Yes | |||
CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS |
5.7.17 | Some | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
ENABLED_ROLES |
8.0.19 | Some | Yes | Yes | Yes | Yes | Yes | Yes | |||
ENGINES |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
EVENTS |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
FILES |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
GLOBAL_STATUS |
8.0.1 | Yes | |||||||||
GLOBAL_VARIABLES |
8.0.1 | Yes | |||||||||
INNODB_BUFFER_PAGE |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_BUFFER_PAGE_LRU |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_BUFFER_POOL_STATS |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_CACHED_INDEXES |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||
INNODB_CMP |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_CMP_PER_INDEX |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_CMP_PER_INDEX_RESET |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_CMP_RESET |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_CMPMEM |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_CMPMEM_RESET |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_COLUMNS |
8.0.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_DATAFILES |
8.0.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_FIELDS |
8.0.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_FOREIGN |
8.0.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_FOREIGN_COLS |
8.0.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_FT_BEING_DELETED |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_FT_CONFIG |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_FT_DEFAULT_STOPWORD |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_FT_DELETED |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_FT_INDEX_CACHE |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_FT_INDEX_TABLE |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_INDEXES |
8.0.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_LOCK_WAITS |
5.7.14 | 8.0.1 | Yes | ||||||||
INNODB_LOCKS |
5.7.14 | 8.0.1 | Yes | ||||||||
INNODB_METRICS |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_SESSION_TEMP_TABLESPACES |
8.0.13 | Some | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_SYS_COLUMNS |
8.0.2 | Yes | |||||||||
INNODB_SYS_DATAFILES |
8.0.2 | Yes | |||||||||
INNODB_SYS_FIELDS |
8.0.2 | Yes | |||||||||
INNODB_SYS_FOREIGN |
8.0.2 | Yes | |||||||||
INNODB_SYS_FOREIGN_COLS |
8.0.2 | Yes | |||||||||
INNODB_SYS_INDEXES |
8.0.2 | Yes | |||||||||
INNODB_SYS_TABLES |
8.0.2 | Yes | |||||||||
INNODB_SYS_TABLESPACES |
8.0.2 | Yes | |||||||||
INNODB_SYS_TABLESTATS |
8.0.2 | Yes | |||||||||
INNODB_SYS_VIRTUAL |
5.7.8 | 8.0.2 | Yes | ||||||||
INNODB_TABLES |
8.0.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_TABLESPACES |
8.0.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_TABLESPACES_BRIEF |
8.0.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_TABLESTATS |
8.0.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_TEMP_TABLE_INFO |
5.7.1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
INNODB_TRX |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
INNODB_VIRTUAL |
8.0.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
KEY_COLUMN_USAGE |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
KEYWORDS |
8.0.11 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
MYSQL_FIREWALL_USERS |
8.0.26 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
MYSQL_FIREWALL_WHITELIST |
8.0.26 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
ndb_transid_mysql_connection_map |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
OPTIMIZER_TRACE |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
PARAMETERS |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
PARTITIONS |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
PLUGINS |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
PROCESSLIST |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
PROFILING |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
REFERENTIAL_CONSTRAINTS |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
RESOURCE_GROUPS |
8.0.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
ROLE_COLUMN_GRANTS |
8.0.19 | Some | Yes | Yes | Yes | Yes | Yes | Yes | |||
ROLE_ROUTINE_GRANTS |
8.0.19 | Some | Yes | Yes | Yes | Yes | Yes | Yes | |||
ROLE_TABLE_GRANTS |
8.0.19 | Some | Yes | Yes | Yes | Yes | Yes | Yes | |||
ROUTINES |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
SCHEMA_PRIVILEGES |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
SCHEMATA |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
SCHEMATA_EXTENSIONS |
8.0.22 | Some | Yes | Yes | Yes | Yes | Yes | Yes | |||
SESSION_STATUS |
8.0.1 | Yes | |||||||||
SESSION_VARIABLES |
8.0.1 | Yes | |||||||||
ST_GEOMETRY_COLUMNS |
8.0.1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
ST_SPATIAL_REFERENCE_SYSTEMS |
8.0.1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
ST_UNITS_OF_MEASURE |
8.0.14 | Some | Yes | Yes | Yes | Yes | Yes | Yes | |||
STATISTICS |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
TABLE_CONSTRAINTS |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
TABLE_CONSTRAINTS_EXTENSIONS |
8.0.21 | Some | Yes | Yes | Yes | Yes | Yes | Yes | |||
TABLE_PRIVILEGES |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
TABLES |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
TABLES_EXTENSIONS |
8.0.21 | Some | Yes | Yes | Yes | Yes | Yes | Yes | |||
TABLESPACES |
8.0.22 | Yes | Yes | Yes | Yes | Yes | |||||
TABLESPACES_EXTENSIONS |
8.0.21 | Some | Yes | Yes | Yes | Yes | Yes | Yes | |||
TP_THREAD_GROUP_STATE |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
TP_THREAD_GROUP_STATS |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
TP_THREAD_STATE |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
TRIGGERS |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
USER_ATTRIBUTES |
8.0.21 | Some | Yes | Yes | Yes | Yes | Yes | Yes | |||
USER_PRIVILEGES |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||
VIEW_ROUTINE_USAGE |
8.0.13 | Some | Yes | Yes | Yes | Yes | Yes | Yes | |||
VIEW_TABLE_USAGE |
8.0.13 | Some | Yes | Yes | Yes | Yes | Yes | Yes | |||
VIEWS |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |