The INFORMATION_SCHEMA INNODB_TABLESPACES Table • ALLOCATED_SIZE • AUTOEXTEND_SIZE • SERVER_VERSION • SPACE_VERSION • ENCRYPTION • STATE • corrupted : The tablespace is identified by  InnoDB  as corrupted. • discarded : The tablespace was discarded by an  ALTER TABLE ... DISCARD TABLESPACE statement. • normal : The tablespace is normal and active. • active : Rollback segments in the undo tablespace can be allocated to new transactions. • inactive : Rollback segments in the undo tablespace are no longer used by new transactions. The truncate process is in progress. The undo tablespace was either selected by the purge thread implicitly or was made inactive by an  ALTER UNDO TABLESPACE ... SET INACTIVE  statement. • empty : The undo tablespace was truncated and is no longer active. It is ready to be dropped or made active again by an  ALTER UNDO TABLESPACE ... SET INACTIVE  statement. Example 4877 mysql>  SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE = 26\G *************************** 1. row *************************** SPACE: 26 NAME: test/t1 FLAG: 0 ROW_FORMAT: Compact or Redundant PAGE_SIZE: 16384  ZIP_PAGE_SIZE: 0 SPACE_TYPE: Single  FS_BLOCK_SIZE: 4096 For undo tablespaces, states include: For file-per-table and general tablespaces, states include: The tablespace state. This column was added in MySQL 8.0.14. Whether the tablespace is encrypted. This column was added in MySQL 8.0.13. The tablespace version, used to track changes to the tablespace format. The MySQL version that created the tablespace, or the MySQL version into which the tablespace was imported, or the version of the last major MySQL version upgrade. The value is unchanged by a release series upgrade, such as an upgrade from MySQL 8.0. x  to 8.0. y . The value can be considered a “creation”  marker or “certified”  marker for the tablespace. The auto-extend size of the tablespace. This column was added in MySQL 8.0.23. The actual size of the file, which is the amount of space allocated on disk. This column pertains to the InnoDB  transparent page compression feature.