MySQL Server Version Reference  /  INFORMATION_SCHEMA Tables

Chapter 4 INFORMATION_SCHEMA Tables

The following table shows all INFORMATION_SCHEMA tables available in MySQL Server 5.7, 8.0, 8.1, 8.2, and 8.3. 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.7, 8.0, 8.1, 8.2, 8.3: 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
ADMINISTRABLE_ROLE_AUTHORIZATIONS 8.0.19 Some Yes Yes Yes
APPLICABLE_ROLES 8.0.19 Some Yes Yes Yes
CHARACTER_SETS Yes Yes Yes Yes Yes
CHECK_CONSTRAINTS 8.0.16 Some Yes Yes Yes
COLLATION_CHARACTER_SET_APPLICABILITY Yes Yes Yes Yes Yes
COLLATIONS Yes Yes Yes Yes Yes
COLUMN_PRIVILEGES Yes Yes Yes Yes Yes
COLUMN_STATISTICS 8.0.2 Yes Yes Yes Yes
COLUMNS Yes Yes Yes Yes Yes
COLUMNS_EXTENSIONS 8.0.21 Some Yes Yes Yes
CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS 5.7.17 Some Yes Yes Yes Yes
ENABLED_ROLES 8.0.19 Some Yes Yes Yes
ENGINES Yes Yes Yes Yes Yes
EVENTS Yes Yes Yes Yes Yes
FILES 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
INNODB_BUFFER_PAGE_LRU Yes Yes Yes Yes Yes
INNODB_BUFFER_POOL_STATS Yes Yes Yes Yes Yes
INNODB_CACHED_INDEXES Yes Yes Yes Yes
INNODB_CMP Yes Yes Yes Yes Yes
INNODB_CMP_PER_INDEX Yes Yes Yes Yes Yes
INNODB_CMP_PER_INDEX_RESET Yes Yes Yes Yes Yes
INNODB_CMP_RESET Yes Yes Yes Yes Yes
INNODB_CMPMEM Yes Yes Yes Yes Yes
INNODB_CMPMEM_RESET Yes Yes Yes Yes Yes
INNODB_COLUMNS 8.0.3 Yes Yes Yes Yes
INNODB_DATAFILES 8.0.3 Yes Yes Yes Yes
INNODB_FIELDS 8.0.3 Yes Yes Yes Yes
INNODB_FOREIGN 8.0.3 Yes Yes Yes Yes
INNODB_FOREIGN_COLS 8.0.3 Yes Yes Yes Yes
INNODB_FT_BEING_DELETED Yes Yes Yes Yes Yes
INNODB_FT_CONFIG Yes Yes Yes Yes Yes
INNODB_FT_DEFAULT_STOPWORD Yes Yes Yes Yes Yes
INNODB_FT_DELETED Yes Yes Yes Yes Yes
INNODB_FT_INDEX_CACHE Yes Yes Yes Yes Yes
INNODB_FT_INDEX_TABLE Yes Yes Yes Yes Yes
INNODB_INDEXES 8.0.3 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
INNODB_SESSION_TEMP_TABLESPACES 8.0.13 Some 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
INNODB_TABLESPACES 8.0.3 Yes Yes Yes Yes
INNODB_TABLESPACES_BRIEF 8.0.3 Yes Yes Yes Yes
INNODB_TABLESTATS 8.0.3 Yes Yes Yes Yes
INNODB_TEMP_TABLE_INFO 5.7.1 Yes Yes Yes Yes Yes
INNODB_TRX Yes Yes Yes Yes Yes
INNODB_VIRTUAL 8.0.3 Yes Yes Yes Yes
KEY_COLUMN_USAGE Yes Yes Yes Yes Yes
KEYWORDS 8.0.11 Yes Yes Yes Yes
MYSQL_FIREWALL_USERS 8.0.26 Yes Yes Yes Yes Yes
MYSQL_FIREWALL_WHITELIST 8.0.26 Yes Yes Yes Yes Yes
ndb_transid_mysql_connection_map Yes Yes Yes Yes Yes
OPTIMIZER_TRACE Yes Yes Yes Yes Yes
PARAMETERS Yes Yes Yes Yes Yes
PARTITIONS Yes Yes Yes Yes Yes
PLUGINS Yes Yes Yes Yes Yes
PROCESSLIST Yes Yes Yes Yes Yes
PROFILING Yes Yes Yes Yes Yes
REFERENTIAL_CONSTRAINTS Yes Yes Yes Yes Yes
RESOURCE_GROUPS 8.0.3 Yes Yes Yes Yes
ROLE_COLUMN_GRANTS 8.0.19 Some Yes Yes Yes
ROLE_ROUTINE_GRANTS 8.0.19 Some Yes Yes Yes
ROLE_TABLE_GRANTS 8.0.19 Some Yes Yes Yes
ROUTINES Yes Yes Yes Yes Yes
SCHEMA_PRIVILEGES Yes Yes Yes Yes Yes
SCHEMATA Yes Yes Yes Yes Yes
SCHEMATA_EXTENSIONS 8.0.22 Some 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
ST_SPATIAL_REFERENCE_SYSTEMS 8.0.1 Yes Yes Yes Yes
ST_UNITS_OF_MEASURE 8.0.14 Some Yes Yes Yes
STATISTICS Yes Yes Yes Yes Yes
TABLE_CONSTRAINTS Yes Yes Yes Yes Yes
TABLE_CONSTRAINTS_EXTENSIONS 8.0.21 Some Yes Yes Yes
TABLE_PRIVILEGES Yes Yes Yes Yes Yes
TABLES Yes Yes Yes Yes Yes
TABLES_EXTENSIONS 8.0.21 Some Yes Yes Yes
TABLESPACES Yes Yes Yes Yes Yes
TABLESPACES_EXTENSIONS 8.0.21 Some Yes Yes Yes
TP_THREAD_GROUP_STATE Yes Yes Yes Yes Yes
TP_THREAD_GROUP_STATS Yes Yes Yes Yes Yes
TP_THREAD_STATE Yes Yes Yes Yes Yes
TRIGGERS Yes Yes Yes Yes Yes
USER_ATTRIBUTES 8.0.21 Some Yes Yes Yes
USER_PRIVILEGES Yes Yes Yes Yes Yes
VIEW_ROUTINE_USAGE 8.0.13 Some Yes Yes Yes
VIEW_TABLE_USAGE 8.0.13 Some Yes Yes Yes
VIEWS Yes Yes Yes Yes Yes