content_image/769960.jpg content_image/769961.jpg
The INNODB_TABLESPACES  table provides metadata about InnoDB  file-per-table, general, and undo tablespaces. 

For related usage information and examples, see Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables” . 

<img src='content_image/769960.jpg'>

The INNODB_TABLESPACES  table has these columns: 

• SPACE 

The tablespace ID. 

• NAME 

The schema (database) and table name. 

• FLAG 

<img src='content_image/769961.jpg'>

## Note 

The INFORMATION_SCHEMA FILES  table reports metadata for InnoDB  tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, the global temporary tablespace, and undo tablespaces. 

A numeric value that represents bit-level information about tablespace format and storage characteristics. 

• ROW_FORMAT 

The tablespace row format ( Compact or Redundant , Dynamic  or Compressed , or Undo ). The data in this column is interpreted from the tablespace flag information that resides in the data file. 

There is no way to determine from this flag information if the tablespace row format is Redundant  or Compact , which is why one of the possible ROW_FORMAT  values is Compact or Redundant . 

• PAGE_SIZE 

The tablespace page size. The data in this column is interpreted from the tablespace flags information that resides in the .ibd  file. 

• ZIP_PAGE_SIZE 

The tablespace zip page size. The data in this column is interpreted from the tablespace flags information that resides in the .ibd  file. 

• SPACE_TYPE 

The type of tablespace. Possible values include General  for general tablespaces, Single  for file-per- table tablespaces, System  for the system tablespace, and Undo  for undo tablespaces. 

• FS_BLOCK_SIZE 

The file system block size, which is the unit size used for hole punching. This column pertains to the InnoDB  transparent page compression feature. 

• FILE_SIZE 

The apparent size of the file, which represents the maximum size of the file, uncompressed. This column pertains to the InnoDB  transparent page compression feature. 

