MySQL 8.4 Release Notes
- 17.15.1 关于压缩的 InnoDB INFORMATION_SCHEMA 表17.15.1 InnoDB INFORMATION_SCHEMA Tables about Compression
- 17.15.2 InnoDB INFORMATION_SCHEMA 事务与锁信息17.15.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Information
- 17.15.3 InnoDB INFORMATION_SCHEMA 模式对象表17.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables
- 17.15.4 InnoDB INFORMATION_SCHEMA 全文索引表17.15.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables
- 17.15.5 InnoDB INFORMATION_SCHEMA 缓冲池表17.15.5 InnoDB INFORMATION_SCHEMA Buffer Pool Tables
- 17.15.6 InnoDB INFORMATION_SCHEMA 指标表17.15.6 InnoDB INFORMATION_SCHEMA Metrics Table
- 17.15.7 InnoDB INFORMATION_SCHEMA 临时表信息表17.15.7 InnoDB INFORMATION_SCHEMA Temporary Table Info Table
- 17.15.8 从 INFORMATION_SCHEMA.FILES 检索 InnoDB 表空间元数据17.15.8 Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES
本节提供关于 InnoDB INFORMATION_SCHEMA 表的信息和使用示例。This section provides information and usage examples for
InnoDB
INFORMATION_SCHEMA tables.
InnoDB INFORMATION_SCHEMA 表提供有关 InnoDB 存储引擎各方面的元数据、状态信息和统计数据。你可以通过在 INFORMATION_SCHEMA 数据库上发出 SHOW TABLES 语句来查看 InnoDB INFORMATION_SCHEMA 表的列表：InnoDB INFORMATION_SCHEMA
tables provide metadata, status information, and statistics about
various aspects of the InnoDB storage engine. You
can view a list of InnoDB
INFORMATION_SCHEMA tables by issuing a
SHOW TABLES statement on the
INFORMATION_SCHEMA database:
mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB%';
有关表定义，请参见 第 28.4 节，“INFORMATION_SCHEMA InnoDB 表”。有关 MySQL INFORMATION_SCHEMA 数据库的一般信息，请参见 第 28 章，INFORMATION_SCHEMA 表。For table definitions, see
Section 28.4, “INFORMATION_SCHEMA InnoDB Tables”. For general
information regarding the MySQL
INFORMATION_SCHEMA database, see
Chapter 28, INFORMATION_SCHEMA Tables.