Documentation Home
MySQL Information Schema
Related Documentation Download this Excerpt
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb


MySQL Information Schema  /  INFORMATION_SCHEMA Table Reference

Chapter 3 INFORMATION_SCHEMA Table Reference

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