Tablespaces InnoDB Page Size (innodb_page_size) Permitted FILE_BLOCK_SIZE Value Permitted KEY_BLOCK_SIZE Value 16KB 1K (1024) 1 8KB 8K (8192) None. If  innodb_page_size is equal to  FILE_BLOCK_SIZE , the tablespace cannot contain a compressed table. 8KB 4K (4096) 4 8KB 2K (2048) 2 8KB 1K (1024) 1 4KB 4K (4096) None. If  innodb_page_size is equal to  FILE_BLOCK_SIZE , the tablespace cannot contain a compressed table. 4KB 2K (2048) 2 4KB 1K (1024) 1 3057 To move a table from the system tablespace or a general tablespace to a file-per-table tablespace, specify innodb_file_per_table  as the tablespace name. To move a table from a general tablespace or file-per-table tablespace to the system tablespace, specify innodb_system  as the tablespace name. To move a table from a file-per-table tablespace or from the system tablespace to a general tablespace, specify the name of the general tablespace. The general tablespace must exist. See  ALTER TABLESPACE for more information. Support for placing table partitions in shared tablespaces was deprecated in MySQL 5.7.24 and removed MySQL 8.0.13. Shared tablespaces include the InnoDB  system tablespace and general tablespaces. ALTER TABLE  with the  TABLESPACE  option can be used to move a table to an existing general tablespace, to a new file-per-table tablespace, or to the system tablespace. If you do not specify  FILE_BLOCK_SIZE  when creating a general tablespace,  FILE_BLOCK_SIZE defaults to  innodb_page_size . When  FILE_BLOCK_SIZE  is equal to  innodb_page_size , the tablespace may only contain tables with an uncompressed row format ( COMPACT ,  REDUNDANT , and DYNAMIC  row formats). This example demonstrates creating a general tablespace and adding a compressed table. The example assumes a default  innodb_page_size  of 16KB. The  FILE_BLOCK_SIZE  of 8192 requires that the compressed table have a  KEY_BLOCK_SIZE  of 8. mysql>  CREATE TABLESPACE ‘ts2‘ ADD DATAFILE ’ts2.ibd’ FILE_BLOCK_SIZE = 8192 Engine=InnoDB; mysql>  CREATE TABLE t4 (c1 INT PRIMARY KEY) TABLESPACE ts2 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8; ALTER TABLE tbl_name TABLESPACE [=]  tablespace_name ; ALTER TABLE tbl_name TABLESPACE [=] innodb_system; Moving Tables Between Tablespaces Using ALTER TABLE Note