10bet网址
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr)- 36.4Mb
PDF (A4)- 36.4Mb
Man Pages (TGZ)- 237.6Kb
Man Pages (Zip)- 349.4Kb
Info (Gzip)- 3.4Mb
Info (Zip)- 3.4Mb
Excerpts from this Manual

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

14.16 InnoDB INFORMATION_SCHEMA Tables

This section provides information and usage examples forInnoDBINFORMATION_SCHEMAtables.

InnoDBINFORMATION_SCHEMAtables provide metadata, status information, and statistics about various aspects of theInnoDBstorage engine. You can view a list ofInnoDBINFORMATION_SCHEMAtables by issuing aSHOW TABLESstatement on theINFORMATION_SCHEMAdatabase:

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

For table definitions, seeSection 24.4, “INFORMATION_SCHEMA InnoDB Tables”. For general information regarding theMySQLINFORMATION_SCHEMAdatabase, seeChapter 24,INFORMATION_SCHEMA Tables.