Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.1Kb
Man Pages (Zip) - 402.3Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  / The InnoDB Storage Engine  /  InnoDB INFORMATION_SCHEMA Tables

17.15 InnoDB INFORMATION_SCHEMA Tables

This section provides information and usage examples forInnoDBINFORMATION_SCHEMA tables.

InnoDBINFORMATION_SCHEMA tables provide metadata, status information, and statistics about various aspects of theInnoDB storage engine. You can view a list ofInnoDBINFORMATION_SCHEMA tables by issuing aSHOW TABLES statement on theINFORMATION_SCHEMA database:

mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB%';

For table definitions, seeSection 28.4, “INFORMATION_SCHEMA InnoDB Tables”. For general information regarding theMySQLINFORMATION_SCHEMA database, seeChapter 28,INFORMATION_SCHEMA Tables.