MySQL 5.6 Release Notes
[+/-]
- 14.15.1 InnoDB INFORMATION_SCHEMA Tables about Compression
- 14.15.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Information
- 14.15.3 InnoDB INFORMATION_SCHEMA System Tables
- 14.15.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables
- 14.15.5 InnoDB INFORMATION_SCHEMA Buffer Pool Tables
- 14.15.6 InnoDB INFORMATION_SCHEMA Metrics Table
This section provides information and usage examples for
InnoDB
INFORMATION_SCHEMA tables.
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%';
For table definitions, see Section 21.30, “INFORMATION_SCHEMA InnoDB Tables”. For
general information regarding the MySQL
INFORMATION_SCHEMA database, see
Chapter 21, INFORMATION_SCHEMA Tables.