Documentation Home
MySQL 9.4 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 41.2Mb
PDF (A4) - 41.3Mb
Man Pages (TGZ) - 262.8Kb
Man Pages (Zip) - 368.8Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


MySQL 9.4 Reference Manual  / INFORMATION_SCHEMA Tables  /  INFORMATION_SCHEMA Table Reference

28.2 INFORMATION_SCHEMA Table Reference

The following table summarizes all availableINFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions.

Table 28.1 INFORMATION_SCHEMA Tables

Table NameDescriptionDeprecated
ADMINISTRABLE_ROLE_AUTHORIZATIONSGrantable users or roles for current user or role
APPLICABLE_ROLESApplicable roles for current user
CHARACTER_SETSAvailable character sets
CHECK_CONSTRAINTSTable and column CHECK constraints
COLLATION_CHARACTER_SET_APPLICABILITYCharacter set applicable to each collation
COLLATIONSCollations for each character set
COLUMN_PRIVILEGESPrivileges defined on columns
COLUMN_STATISTICSHistogram statistics for column values
COLUMNSColumns in each table
COLUMNS_EXTENSIONSColumn attributes for primary and secondary storage engines
CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTSCurrent number of consecutive failed connection attempts per accountYes
ENABLED_ROLESRoles enabled within current session
ENGINESStorage engine properties
EVENTSEvent Manager events
FILESFiles that store tablespace data
INNODB_BUFFER_PAGEPages in InnoDB buffer pool
INNODB_BUFFER_PAGE_LRULRU ordering of pages in InnoDB buffer pool
INNODB_BUFFER_POOL_STATSInnoDB buffer pool statistics
INNODB_CACHED_INDEXESNumber of index pages cached per index in InnoDB buffer pool
INNODB_CMPStatus for operations related to compressed InnoDB tables
INNODB_CMP_PER_INDEXStatus for operations related to compressed InnoDB tables and indexes
INNODB_CMP_PER_INDEX_RESETStatus for operations related to compressed InnoDB tables and indexes
INNODB_CMP_RESETStatus for operations related to compressed InnoDB tables
INNODB_CMPMEMStatus for compressed pages within InnoDB buffer pool
INNODB_CMPMEM_RESETStatus for compressed pages within InnoDB buffer pool
INNODB_COLUMNSColumns in each InnoDB table
INNODB_DATAFILESData file path information for InnoDB file-per-table and general tablespaces
INNODB_FIELDSKey columns of InnoDB indexes
INNODB_FOREIGNInnoDB foreign-key metadata
INNODB_FOREIGN_COLSInnoDB foreign-key column status information
INNODB_FT_BEING_DELETEDSnapshot of INNODB_FT_DELETED table
INNODB_FT_CONFIGMetadata for InnoDB table FULLTEXT index and associated processing
INNODB_FT_DEFAULT_STOPWORDDefault list of stopwords for InnoDB FULLTEXT indexes
INNODB_FT_DELETEDRows deleted from InnoDB table FULLTEXT index
INNODB_FT_INDEX_CACHEToken information for newly inserted rows in InnoDB FULLTEXT index
INNODB_FT_INDEX_TABLEInverted index information for processing text searches against InnoDB table FULLTEXT index
INNODB_INDEXESInnoDB index metadata
INNODB_METRICSInnoDB performance information
INNODB_SESSION_TEMP_TABLESPACESSession temporary-tablespace metadata
INNODB_TABLESInnoDB table metadata
INNODB_TABLESPACESInnoDB file-per-table, general, and undo tablespace metadata
INNODB_TABLESPACES_BRIEFBrief file-per-table, general, undo, and system tablespace metadata
INNODB_TABLESTATSInnoDB table low-level status information
INNODB_TEMP_TABLE_INFOInformation about active user-created InnoDB temporary tables
INNODB_TRXActive InnoDB transaction information
INNODB_VIRTUALInnoDB virtual generated column metadata
JSON_DUALITY_VIEW_COLUMNSColumns referenced by JSON duality views
JSON_DUALITY_VIEW_LINKSParent-child relationships between tables referenced by JSON duality views
JSON_DUALITY_VIEW_TABLESTables referenced by JSON duality views
JSON_DUALITY_VIEWSJSON duality views
KEY_COLUMN_USAGEWhich key columns have constraints
KEYWORDSMySQL keywords
LIBRARIESInformation about JavaScript libraries
MYSQL_FIREWALL_USERSFirewall in-memory data for account profilesYes
MYSQL_FIREWALL_WHITELISTFirewall in-memory data for account profile allowlistsYes
ndb_transid_mysql_connection_mapNDB transaction information
OPTIMIZER_TRACEInformation produced by optimizer trace activity
PARAMETERSStored routine parameters and stored function return values
PARTITIONSTable partition information
PLUGINSPlugin information
PROCESSLISTInformation about currently executing threads
PROFILINGStatement profiling information
REFERENTIAL_CONSTRAINTSForeign key information
RESOURCE_GROUPSResource group information
ROLE_COLUMN_GRANTSColumn privileges for roles available to or granted by currently enabled roles
ROLE_ROUTINE_GRANTSRoutine privileges for roles available to or granted by currently enabled roles
ROLE_TABLE_GRANTSTable privileges for roles available to or granted by currently enabled roles
ROUTINE_LIBRARIESInformation about libraries used in JavaScript stored routines
ROUTINESStored routine information
SCHEMA_PRIVILEGESPrivileges defined on schemas
SCHEMATASchema information
SCHEMATA_EXTENSIONSSchema options
ST_GEOMETRY_COLUMNSColumns in each table that store spatial data
ST_SPATIAL_REFERENCE_SYSTEMSAvailable spatial reference systems
ST_UNITS_OF_MEASUREAcceptable units for ST_Distance()
STATISTICSTable index statistics
TABLE_CONSTRAINTSWhich tables have constraints
TABLE_CONSTRAINTS_EXTENSIONSTable constraint attributes for primary and secondary storage engines
TABLE_PRIVILEGESPrivileges defined on tables
TABLESTable information
TABLES_EXTENSIONSTable attributes for primary and secondary storage engines
TABLESPACES_EXTENSIONSTablespace attributes for primary storage engines
TP_THREAD_GROUP_STATEThread pool thread group states
TP_THREAD_GROUP_STATSThread pool thread group statistics
TP_THREAD_STATEThread pool thread information
TRIGGERSTrigger information
USER_ATTRIBUTESUser comments and attributes
USER_PRIVILEGESPrivileges defined globally per user
VIEW_ROUTINE_USAGEStored functions used in views
VIEW_TABLE_USAGETables and views used in views
VIEWSView information