MySQL 8.4 Release Notes
下表总结了 INFORMATION_SCHEMA InnoDB 表。如需更详细信息，请参阅各个表的描述。The following table summarizes
INFORMATION_SCHEMA InnoDB tables. For greater
detail, see the individual table descriptions.
表 28.3 INFORMATION_SCHEMA InnoDB 表Table 28.3 INFORMATION_SCHEMA InnoDB Tables
| 表名Table Name | 说明Description |
|---|---|
INNODB_BUFFER_PAGEINNODB_BUFFER_PAGE |
InnoDB 缓冲池中的页面Pages in InnoDB buffer pool |
INNODB_BUFFER_PAGE_LRUINNODB_BUFFER_PAGE_LRU |
InnoDB 缓冲池中页面的 LRU 顺序LRU ordering of pages in InnoDB buffer pool |
INNODB_BUFFER_POOL_STATSINNODB_BUFFER_POOL_STATS |
InnoDB 缓冲池统计信息InnoDB buffer pool statistics |
INNODB_CACHED_INDEXESINNODB_CACHED_INDEXES |
InnoDB 缓冲池中每个索引的索引页缓存数量Number of index pages cached per index in InnoDB buffer pool |
INNODB_CMPINNODB_CMP |
与压缩 InnoDB 表相关操作的状态Status for operations related to compressed InnoDB tables |
INNODB_CMP_PER_INDEXINNODB_CMP_PER_INDEX |
与压缩 InnoDB 表和索引相关操作的状态Status for operations related to compressed InnoDB tables and indexes |
INNODB_CMP_PER_INDEX_RESETINNODB_CMP_PER_INDEX_RESET |
与压缩 InnoDB 表和索引相关操作的状态Status for operations related to compressed InnoDB tables and indexes |
INNODB_CMP_RESETINNODB_CMP_RESET |
与压缩 InnoDB 表相关操作的状态Status for operations related to compressed InnoDB tables |
INNODB_CMPMEMINNODB_CMPMEM |
InnoDB 缓冲池中压缩页的状态Status for compressed pages within InnoDB buffer pool |
INNODB_CMPMEM_RESETINNODB_CMPMEM_RESET |
InnoDB 缓冲池中压缩页的状态Status for compressed pages within InnoDB buffer pool |
INNODB_COLUMNSINNODB_COLUMNS |
每个 InnoDB 表的列Columns in each InnoDB table |
INNODB_DATAFILESINNODB_DATAFILES |
InnoDB 文件按表和通用表空间的数据文件路径信息Data file path information for InnoDB file-per-table and general tablespaces |
INNODB_FIELDSINNODB_FIELDS |
InnoDB 索引的关键列Key columns of InnoDB indexes |
INNODB_FOREIGNINNODB_FOREIGN |
InnoDB 外键元数据InnoDB foreign-key metadata |
INNODB_FOREIGN_COLSINNODB_FOREIGN_COLS |
InnoDB 外键列状态信息InnoDB foreign-key column status information |
INNODB_FT_BEING_DELETEDINNODB_FT_BEING_DELETED |
INNODB_FT_DELETED 表的快照Snapshot of INNODB_FT_DELETED table |
INNODB_FT_CONFIGINNODB_FT_CONFIG |
InnoDB 表 FULLTEXT 索引及相关处理的元数据Metadata for InnoDB table FULLTEXT index and associated processing |
INNODB_FT_DEFAULT_STOPWORDINNODB_FT_DEFAULT_STOPWORD |
InnoDB FULLTEXT 索引的默认停用词列表Default list of stopwords for InnoDB FULLTEXT indexes |
INNODB_FT_DELETEDINNODB_FT_DELETED |
从 InnoDB 表的全文索引中删除的行Rows deleted from InnoDB table FULLTEXT index |
INNODB_FT_INDEX_CACHEINNODB_FT_INDEX_CACHE |
InnoDB 全文索引中新插入行的分词信息Token information for newly inserted rows in InnoDB FULLTEXT index |
INNODB_FT_INDEX_TABLEINNODB_FT_INDEX_TABLE |
处理针对 InnoDB 表全文索引的文本搜索的倒排索引信息Inverted index information for processing text searches against InnoDB table FULLTEXT index |
INNODB_INDEXESINNODB_INDEXES |
InnoDB 索引元数据InnoDB index metadata |
INNODB_METRICSINNODB_METRICS |
InnoDB 性能信息InnoDB performance information |
INNODB_SESSION_TEMP_TABLESPACESINNODB_SESSION_TEMP_TABLESPACES |
会话临时表空间元数据Session temporary-tablespace metadata |
INNODB_TABLESINNODB_TABLES |
InnoDB 表元数据InnoDB table metadata |
INNODB_TABLESPACESINNODB_TABLESPACES |
InnoDB 按表存储、通用和回滚表空间元数据InnoDB file-per-table, general, and undo tablespace metadata |
INNODB_TABLESPACES_BRIEFINNODB_TABLESPACES_BRIEF |
简要的按表存储、通用、回滚及系统表空间元数据Brief file-per-table, general, undo, and system tablespace metadata |
INNODB_TABLESTATSINNODB_TABLESTATS |
InnoDB 表底层状态信息InnoDB table low-level status information |
INNODB_TEMP_TABLE_INFOINNODB_TEMP_TABLE_INFO |
关于活动的用户创建的 InnoDB 临时表的信息Information about active user-created InnoDB temporary tables |
INNODB_TRXINNODB_TRX |
活动的 InnoDB 事务信息Active InnoDB transaction information |
INNODB_VIRTUALINNODB_VIRTUAL |
InnoDB 虚拟生成列的元数据InnoDB virtual generated column metadata |