MySQL 5.7 Release Notes
- 14.16.1 InnoDB INFORMATION_SCHEMA Tables about Compression
- 14.16.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Information
- 14.16.3 InnoDB INFORMATION_SCHEMA System Tables
- 14.16.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables
- 14.16.5 InnoDB INFORMATION_SCHEMA Buffer Pool Tables
- 14.16.6 InnoDB INFORMATION_SCHEMA Metrics Table
- 14.16.7 InnoDB INFORMATION_SCHEMA Temporary Table Info Table
- 14.16.8 Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES
This section provides information and usage examples forInnoDB
INFORMATION_SCHEMA
tables.
InnoDB
INFORMATION_SCHEMA
tables provide metadata, status information, and statistics about various aspects of theInnoDB
storage engine. You can view a list ofInnoDB
INFORMATION_SCHEMA
tables by issuing aSHOW TABLES
statement on theINFORMATION_SCHEMA
database:
mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB%';
For table definitions, seeSection 24.4, “INFORMATION_SCHEMA InnoDB Tables”. For general information regarding theMySQL
INFORMATION_SCHEMA
database, seeChapter 24,INFORMATION_SCHEMA Tables.