This section provides information and usage examples for InnoDB INFORMATION_SCHEMA.

InnoDB INFORMATION_SCHEMA 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 28.4. For general information regarding the MySQL INFORMATION_SCHEMA database, see Chapter 28,.