Tablespaces Adding Tables to a General Tablespace General Tablespace Row Format Support After creating a general tablespace   CREATE TABLE  tbl_name  ... TABLESPACE [=] tablespace_name  or  ALTER TABLE  tbl_name  TABLESPACE [=]  tablespace_name  statements can be used to add tables to the tablespace  as shown in the following examples: CREATE TABLE : ALTER TABLE : Support for adding table partitions to shared tablespaces was deprecated in MySQL 5.7.24 and removed in MySQL 8.0.13. Shared tablespaces include the  InnoDB system tablespace and general tablespaces. For detailed syntax information  see  CREATE TABLE  and  ALTER TABLE . General tablespaces support all table row formats ( REDUNDANT    COMPACT    DYNAMIC    COMPRESSED ) with the caveat that compressed and uncompressed tables cannot coexist in the same general tablespace due to different physical page sizes. For a general tablespace to contain compressed tables ( ROW_FORMAT=COMPRESSED )  the FILE_BLOCK_SIZE  option must be specified  and the  FILE_BLOCK_SIZE  value must be a valid compressed page size in relation to the  innodb_page_size  value. Also  the physical page size of the compressed table ( KEY_BLOCK_SIZE ) must be equal to  FILE_BLOCK_SIZE/1024 . For example  if innodb_page_size=16KB  and  FILE_BLOCK_SIZE=8K   the  KEY_BLOCK_SIZE  of the table must be 8. The following table shows permitted  innodb_page_size    FILE_BLOCK_SIZE   and  KEY_BLOCK_SIZE combinations.  FILE_BLOCK_SIZE  values may also be specified in bytes. To determine a valid KEY_BLOCK_SIZE  value for a given  FILE_BLOCK_SIZE   divide the  FILE_BLOCK_SIZE  value by 1024. Table compression is not support for 32K and 64K  InnoDB  page sizes. For more information about KEY_BLOCK_SIZE   see  CREATE TABLE   and Section 15.9.1.2  “Creating Compressed Tables” . 3056 Table 15.3 Permitted Page Size  FILE_BLOCK_SIZE  and KEY_BLOCK_SIZE Combinations for Compressed Tables InnoDB Page Size (innodb_page_size) Permitted FILE_BLOCK_SIZE Value Permitted KEY_BLOCK_SIZE Value 64KB 64K (65536) Compression is not supported 32KB 32K (32768) Compression is not supported 16KB 16K (16384) None. If  innodb_page_size is equal to  FILE_BLOCK_SIZE   the tablespace cannot contain a compressed table. 16KB 8K (8192) 8 16KB 4K (4096) 4 16KB 2K (2048) 2 mysql>  CREATE TABLE t1 (c1 INT PRIMARY KEY) TABLESPACE ts1; mysql>  ALTER TABLE t2 TABLESPACE ts1; Note