The following table summarizes all available 'INFORMATION_SCHEMA' tables. For greater detail, see the individual table descriptions.
INFORMATION_SCHEMA Tables
Table Name Description IntroducedDeprecated
*note 'CHARACTER_SETS': information-schema-character-sets-table.
Available character sets
*note 'COLLATION_CHARACTER_SET_APPLICABILITY': information-schema-collation-character-set-applicability-table.
Character set applicable to each collation
*note 'COLLATIONS': information-schema-collations-table.
Collations for each character set
*note 'COLUMN_PRIVILEGES': information-schema-column-privileges-table.
Privileges defined on columns
*note 'COLUMNS': information-schema-columns-table.
Columns in each table
*note 'CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS': information-schema-connection-control-failed-login-attempts-table.
Current number 5.7.17 of consecutive
failed connection attempts per account
*note 'ENGINES': information-schema-engines-table.
Storage engine properties
*note 'EVENTS': information-schema-events-table.
Event Manager events
*note 'FILES': information-schema-files-table.
Files that store tablespace data
*note 'GLOBAL_STATUS': information-schema-status-table.
Global status variables
*note 'GLOBAL_VARIABLES': information-schema-variables-table.
Global system variables
*note 'INNODB_BUFFER_PAGE': information-schema-innodb-buffer-page-table.
Pages in InnoDB buffer pool
*note 'INNODB_BUFFER_PAGE_LRU': information-schema-innodb-buffer-page-lru-table.
LRU ordering of pages in InnoDB buffer pool
*note 'INNODB_BUFFER_POOL_STATS': information-schema-innodb-buffer-pool-stats-table.
InnoDB buffer pool statistics
*note 'INNODB_CMP': information-schema-innodb-cmp-table.
Status for operations related to compressed InnoDB tables
*note 'INNODB_CMP_PER_INDEX': information-schema-innodb-cmp-per-index-table.
Status for operations related to compressed InnoDB tables and indexes
*note 'INNODB_CMP_PER_INDEX_RESET': information-schema-innodb-cmp-per-index-table.
Status for operations related to compressed InnoDB tables and indexes
*note 'INNODB_CMP_RESET': information-schema-innodb-cmp-table.
Status for operations related to compressed InnoDB tables
*note 'INNODB_CMPMEM': information-schema-innodb-cmpmem-table.
Status for compressed pages within InnoDB buffer pool
*note 'INNODB_CMPMEM_RESET': information-schema-innodb-cmpmem-table.
Status for compressed pages within InnoDB buffer pool
*note 'INNODB_FT_BEING_DELETED': information-schema-innodb-ft-being-deleted-table.
Snapshot of INNODB_FT_DELETED table
*note 'INNODB_FT_CONFIG': information-schema-innodb-ft-config-table.
Metadata for InnoDB table FULLTEXT index and associated processing
*note 'INNODB_FT_DEFAULT_STOPWORD': information-schema-innodb-ft-default-stopword-table.
Default list of stopwords for InnoDB FULLTEXT indexes
*note 'INNODB_FT_DELETED': information-schema-innodb-ft-deleted-table.
Rows deleted from InnoDB table FULLTEXT index
*note 'INNODB_FT_INDEX_CACHE': information-schema-innodb-ft-index-cache-table.
Token information for newly inserted rows in InnoDB FULLTEXT index
*note 'INNODB_FT_INDEX_TABLE': information-schema-innodb-ft-index-table-table.
Inverted index information for processing text searches against InnoDB table FULLTEXT index
*note 'INNODB_LOCK_WAITS': information-schema-innodb-lock-waits-table.
InnoDB 5.7.14 transaction
lock-wait information
*note 'INNODB_LOCKS': information-schema-innodb-locks-table.
InnoDB 5.7.14 transaction
lock information
*note 'INNODB_METRICS': information-schema-innodb-metrics-table.
InnoDB performance information
*note 'INNODB_SYS_COLUMNS': information-schema-innodb-sys-columns-table.
Columns in each InnoDB table
*note 'INNODB_SYS_DATAFILES': information-schema-innodb-sys-datafiles-table.
Data file path information for InnoDB file-per-table and general tablespaces
*note 'INNODB_SYS_FIELDS': information-schema-innodb-sys-fields-table.
Key columns of InnoDB indexes
*note 'INNODB_SYS_FOREIGN': information-schema-innodb-sys-foreign-table.
InnoDB foreign-key metadata
*note 'INNODB_SYS_FOREIGN_COLS': information-schema-innodb-sys-foreign-cols-table.
InnoDB foreign-key column status information
*note 'INNODB_SYS_INDEXES': information-schema-innodb-sys-indexes-table.
InnoDB index metadata
*note 'INNODB_SYS_TABLES': information-schema-innodb-sys-tables-table.
InnoDB table metadata
*note 'INNODB_SYS_TABLESPACES': information-schema-innodb-sys-tablespaces-table.
InnoDB file-per-table, general, and undo tablespace metadata
*note 'INNODB_SYS_TABLESTATS': information-schema-innodb-sys-tablestats-table.
InnoDB table low-level status information
*note 'INNODB_SYS_VIRTUAL': information-schema-innodb-sys-virtual-table.
InnoDB virtual generated column metadata
*note 'INNODB_TEMP_TABLE_INFO': information-schema-innodb-temp-table-info-table.
Information about active user-created InnoDB temporary tables
*note 'INNODB_TRX': information-schema-innodb-trx-table.
Active InnoDB transaction information
*note 'KEY_COLUMN_USAGE': information-schema-key-column-usage-table.
Which key columns have constraints
*note 'MYSQL_FIREWALL_USERS': information-schema-mysql-firewall-users-table.
Firewall in-memory data for account profiles
*note 'MYSQL_FIREWALL_WHITELIST': information-schema-mysql-firewall-whitelist-table.
Firewall in-memory data for account profile allowlists
*note 'ndb_transid_mysql_connection_map': information-schema-ndb-transid-mysql-connection-map-table.
NDB transaction information
*note 'OPTIMIZER_TRACE': information-schema-optimizer-trace-table.
Information produced by optimizer trace activity
*note 'PARAMETERS': information-schema-parameters-table.
Stored routine parameters and stored function return values
*note 'PARTITIONS': information-schema-partitions-table.
Table partition information
*note 'PLUGINS': information-schema-plugins-table.
Plugin information
*note 'PROCESSLIST': information-schema-processlist-table.
Information about currently executing threads
*note 'PROFILING': information-schema-profiling-table.
Statement profiling information
*note 'REFERENTIAL_CONSTRAINTS': information-schema-referential-constraints-table.
Foreign key information
*note 'ROUTINES': information-schema-routines-table.
Stored routine information
*note 'SCHEMA_PRIVILEGES': information-schema-schema-privileges-table.
Privileges defined on schemas
*note 'SCHEMATA': information-schema-schemata-table.
Schema information
*note 'SESSION_STATUS': information-schema-status-table.
Status variables for current session
*note 'SESSION_VARIABLES': information-schema-variables-table.
System variables for current session
*note 'STATISTICS': information-schema-statistics-table.
Table index statistics
*note 'TABLE_CONSTRAINTS': information-schema-table-constraints-table.
Which tables have constraints
*note 'TABLE_PRIVILEGES': information-schema-table-privileges-table.
Privileges defined on tables
*note 'TABLES': information-schema-tables-table.
Table information
*note 'TABLESPACES': information-schema-tablespaces-table.
Tablespace information
*note 'TP_THREAD_GROUP_STATE': information-schema-tp-thread-group-state-table.
Thread pool thread group states
*note 'TP_THREAD_GROUP_STATS': information-schema-tp-thread-group-stats-table.
Thread pool thread group statistics
*note 'TP_THREAD_STATE': information-schema-tp-thread-state-table.
Thread pool thread information
*note 'TRIGGERS': information-schema-triggers-table.
Trigger information
*note 'USER_PRIVILEGES': information-schema-user-privileges-table.
Privileges defined globally per user
*note 'VIEWS': information-schema-views-table.
View information
File: manual.info.tmp, Node: general-information-schema-tables, Next: innodb-information-schema-tables, Prev: information-schema-table-reference, Up: information-schema