INNODB_TABLES table provides
For related usage information and examples, see Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”.
INNODB_TABLES table has these
An identifier for the
InnoDBtable. This value is unique across all databases in the instance.
The name of the table, preceded by the schema (database) name where appropriate (for example,
test/t1). Names of databases and user tables are in the same case as they were originally defined, possibly influenced by the
A numeric value that represents bit-level information about table format and storage characteristics.
The number of columns in the table. The number reported includes three hidden columns that are created by
DB_ROLL_PTR). The number reported also includes virtual generated columns, if present.
An identifier for the tablespace where the table resides. 0 means the
InnoDBsystem tablespace. Any other number represents either a file-per-table tablespace or a general tablespace. This identifier stays the same after a
TRUNCATE TABLEstatement. For file-per-table tablespaces, this identifier is unique for tables across all databases in the instance.
The table's row format (
The zip page size. Applies only to tables with a row format of
The type of tablespace to which the table belongs. Possible values include
Systemfor the system tablespace,
Generalfor general tablespaces, and
Singlefor file-per-table tablespaces. Tables assigned to the system tablespace using
General. For more information, see
The number of columns that existed before the first instant column was added using
ALTER TABLE ... ADD COLUMNwith
ALGORITHM=INSTANT. This column is no longer used as of MySQL 8.0.29 but continues to show information for tables with columns that were added instantly prior to MySQL 8.0.29.
The number of row versions for the table. The initial value is 0. The value is incremented each time a column is added or dropped using
ALTER TABLE ... ADD COLUMNor
ALGORITHM=INSTANT. When a table with instantly added or dropped columns is rebuilt due to a table-rebuilding
OPTIMIZE TABLEoperation, the value is reset to 0. For more information, see Column Operations.
mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE TABLE_ID = 214\G *************************** 1. row *************************** TABLE_ID: 1064 NAME: test/t1 FLAG: 33 N_COLS: 6 SPACE: 3 ROW_FORMAT: Dynamic ZIP_PAGE_SIZE: 0 SPACE_TYPE: Single INSTANT_COLS: 0 TOTAL_ROW_VERSIONS: 3