The INFORMATION_SCHEMA INNODB_TABLESPACES Table 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” . 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. The  INNODB_TABLESPACES  table has these columns: The tablespace ID. The schema (database) and table name. A numeric value that represents bit-level information about tablespace format and storage characteristics. 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 . The tablespace page size. The data in this column is interpreted from the tablespace flags information that resides in the  .ibd  file. The tablespace zip page size. The data in this column is interpreted from the tablespace flags information that resides in the  .ibd  file. 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. The file system block size, which is the unit size used for hole punching. This column pertains to the InnoDB  transparent page compression feature. 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. 4876 • FILE_SIZE • FS_BLOCK_SIZE • SPACE_TYPE • ZIP_PAGE_SIZE • PAGE_SIZE • ROW_FORMAT • FLAG • NAME • SPACE Note