MySQL Server Version Reference  /  INFORMATION_SCHEMA Tables

Chapter 4 INFORMATION_SCHEMA Tables

The following table shows all INFORMATION_SCHEMA tables available across MySQL Server 5.6 through 8.0. 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.

  • 5.6, 5.7, and so forth: 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.6 5.7 8.0
ADMINISTRABLE_ROLE_AUTHORIZATIONS 8.0.19 Some
APPLICABLE_ROLES 8.0.19 Some
CHARACTER_SETS Yes Yes Yes
CHECK_CONSTRAINTS 8.0.16 Some
COLLATION_CHARACTER_SET_APPLICABILITY Yes Yes Yes
COLLATIONS Yes Yes Yes
COLUMN_PRIVILEGES Yes Yes Yes
COLUMN_STATISTICS 8.0.2 Yes
COLUMNS Yes Yes Yes
COLUMNS_EXTENSIONS 8.0.21 Some
CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS 5.6.35, 5.7.17 Some Some Yes
ENABLED_ROLES 8.0.19 Some
ENGINES Yes Yes Yes
EVENTS Yes Yes Yes
FILES Yes Yes Yes
GLOBAL_STATUS 8.0.1 Yes Yes
GLOBAL_VARIABLES 8.0.1 Yes Yes
INNODB_BUFFER_PAGE Yes Yes Yes
INNODB_BUFFER_PAGE_LRU Yes Yes Yes
INNODB_BUFFER_POOL_STATS Yes Yes Yes
INNODB_CACHED_INDEXES Yes
INNODB_CMP Yes Yes Yes
INNODB_CMP_PER_INDEX 5.6.7 Yes Yes Yes
INNODB_CMP_PER_INDEX_RESET 5.6.7 Yes Yes Yes
INNODB_CMP_RESET Yes Yes Yes
INNODB_CMPMEM Yes Yes Yes
INNODB_CMPMEM_RESET Yes Yes Yes
INNODB_COLUMNS 8.0.3 Yes
INNODB_DATAFILES 8.0.3 Yes
INNODB_FIELDS 8.0.3 Yes
INNODB_FOREIGN 8.0.3 Yes
INNODB_FOREIGN_COLS 8.0.3 Yes
INNODB_FT_BEING_DELETED 5.6.4 Yes Yes Yes
INNODB_FT_CONFIG 5.6.4 Yes Yes Yes
INNODB_FT_DEFAULT_STOPWORD 5.6.4 Yes Yes Yes
INNODB_FT_DELETED 5.6.4 Yes Yes Yes
INNODB_FT_INDEX_CACHE 5.6.4 Yes Yes Yes
INNODB_FT_INDEX_TABLE 5.6.4 Yes Yes Yes
INNODB_INDEXES 8.0.3 Yes
INNODB_LOCK_WAITS 5.7.14 8.0.1 Yes Yes
INNODB_LOCKS 5.7.14 8.0.1 Yes Yes
INNODB_METRICS 5.6.2 Yes Yes Yes
INNODB_SESSION_TEMP_TABLESPACES 8.0.13 Some
INNODB_SYS_COLUMNS 8.0.2 Yes Yes
INNODB_SYS_DATAFILES 5.6.6 8.0.2 Yes Yes
INNODB_SYS_FIELDS 8.0.2 Yes Yes
INNODB_SYS_FOREIGN 8.0.2 Yes Yes
INNODB_SYS_FOREIGN_COLS 8.0.2 Yes Yes
INNODB_SYS_INDEXES 8.0.2 Yes Yes
INNODB_SYS_TABLES 8.0.2 Yes Yes
INNODB_SYS_TABLESPACES 5.6.6 8.0.2 Yes Yes
INNODB_SYS_TABLESTATS 8.0.2 Yes Yes
INNODB_SYS_VIRTUAL 5.7.8 8.0.2 Yes
INNODB_TABLES 8.0.3 Yes
INNODB_TABLESPACES 8.0.3 Yes
INNODB_TABLESPACES_BRIEF 8.0.3 Yes
INNODB_TABLESTATS 8.0.3 Yes
INNODB_TEMP_TABLE_INFO 5.7.1 Yes Yes
INNODB_TRX Yes Yes Yes
INNODB_VIRTUAL 8.0.3 Yes
KEY_COLUMN_USAGE Yes Yes Yes
KEYWORDS 8.0.11 Yes
MYSQL_FIREWALL_USERS 8.0.26 Yes Yes Yes
MYSQL_FIREWALL_WHITELIST 8.0.26 Yes Yes Yes
ndb_transid_mysql_connection_map Yes Yes Yes
OPTIMIZER_TRACE 5.6.3 Yes Yes Yes
PARAMETERS Yes Yes Yes
PARTITIONS Yes Yes Yes
PLUGINS Yes Yes Yes
PROCESSLIST Yes Yes Yes
PROFILING Yes Yes Yes
REFERENTIAL_CONSTRAINTS Yes Yes Yes
RESOURCE_GROUPS 8.0.3 Yes
ROLE_COLUMN_GRANTS 8.0.19 Some
ROLE_ROUTINE_GRANTS 8.0.19 Some
ROLE_TABLE_GRANTS 8.0.19 Some
ROUTINES Yes Yes Yes
SCHEMA_PRIVILEGES Yes Yes Yes
SCHEMATA Yes Yes Yes
SCHEMATA_EXTENSIONS 8.0.22 Some
SESSION_STATUS 8.0.1 Yes Yes
SESSION_VARIABLES 8.0.1 Yes Yes
ST_GEOMETRY_COLUMNS 8.0.1 Yes
ST_SPATIAL_REFERENCE_SYSTEMS 8.0.1 Yes
ST_UNITS_OF_MEASURE 8.0.14 Some
STATISTICS Yes Yes Yes
TABLE_CONSTRAINTS Yes Yes Yes
TABLE_CONSTRAINTS_EXTENSIONS 8.0.21 Some
TABLE_PRIVILEGES Yes Yes Yes
TABLES Yes Yes Yes
TABLES_EXTENSIONS 8.0.21 Some
TABLESPACES Yes Yes Yes
TABLESPACES_EXTENSIONS 8.0.21 Some
TP_THREAD_GROUP_STATE Yes Yes Yes
TP_THREAD_GROUP_STATS Yes Yes Yes
TP_THREAD_STATE Yes Yes Yes
TRIGGERS Yes Yes Yes
USER_ATTRIBUTES 8.0.21 Some
USER_PRIVILEGES Yes Yes Yes
VIEW_ROUTINE_USAGE 8.0.13 Some
VIEW_TABLE_USAGE 8.0.13 Some
VIEWS Yes Yes Yes