Skip navigation links
MySQL 5.6 Reference Manual :: 14 The InnoDB Storage Engine :: 14.14 InnoDB INFORMATION_SCHEMA Tables
14.14.1 InnoDB INFORMATION_SCHEMA Tables about Compression »
Section Navigation      [Toggle]

14.14 InnoDB INFORMATION_SCHEMA Tables

[+/-]

14.14.1 InnoDB INFORMATION_SCHEMA Tables about Compression
14.14.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Tables
14.14.3 InnoDB INFORMATION_SCHEMA System Tables
14.14.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables
14.14.5 InnoDB INFORMATION_SCHEMA Buffer Pool Tables
14.14.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.29, “INFORMATION_SCHEMA Tables for InnoDB”. For general information regarding the MySQL INFORMATION_SCHEMA database, see Chapter 21, INFORMATION_SCHEMA Tables.


User Comments