21.29.15 The INFORMATION_SCHEMA INNODB_SYS_TABLESPACES Table

The INNODB_SYS_TABLESPACES table stores information about InnoDB tablespaces, allowing it to be queried through INFORMATION_SCHEMA.

Table 21.15 INNODB_SYS_TABLESPACES Columns

Column nameDescription
SPACETablespace Space ID.
NAMEThe database and table name (for example, world_innodb\city)
FLAGThe table was created with the CREATE TABLE ... DATA DIRECTORY (0 = false, 1 = true)
FILE_FORMATThe tablespace file format (for example, Antelope or Barracuda). The data in this field is interpreted from the tablespace flags information that resides in the .ibd file. For more information about InnoDB file formats, see Section 14.8, “InnoDB File-Format Management”.
ROW_FORMATThe tablespace row format (for example, Compact or Redundant). The data in this field is interpreted from the tablespace flags information that resides in the .ibd file.
PAGE_SIZEThe tablespace page size. The data in this field is interpreted from the tablespace flags information that resides in the .ibd file.
ZIP_PAGE_SIZEThe tablespace zip page size. The data in this field is interpreted from the tablespace flags information that resides in the .ibd file.

Notes: