• ALLOCATED_SIZE 

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. 

• AUTOEXTEND_SIZE 

The auto-extend size of the tablespace. This column was added in MySQL 8.0.23. 

• SERVER_VERSION 

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. 

• SPACE_VERSION 

The tablespace version, used to track changes to the tablespace format. 

• ENCRYPTION 

Whether the tablespace is encrypted. This column was added in MySQL 8.0.13. 

• STATE 

The tablespace state. This column was added in MySQL 8.0.14. 

For file-per-table and general tablespaces, states include: 

• normal : The tablespace is normal and active. 

• discarded : The tablespace was discarded by an ALTER TABLE ... DISCARD TABLESPACE statement. 

• corrupted : The tablespace is identified by InnoDB  as corrupted. 

For undo tablespaces, states include: 

• 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. 

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 

