Tablespaces •If the tablespace is more than 32 extents in size, it is extended four extents at a time. For information about extent size, see Section 15.11.2, “File Space Management” . From MySQL 8.0.23, the amount by which a file-per-table or general tablespace is extended is configurable by specifying the  AUTOEXTEND_SIZE  option. Configuring a larger extension size can help avoid fragmentation and facilitate ingestion of large amounts of data. To configure the extension size for a file-per-table tablespace, specify the  AUTOEXTEND_SIZE  size in a CREATE TABLE  or  ALTER TABLE  statement: To configure the extension size for a general tablespace, specify the  AUTOEXTEND_SIZE  size in a  CREATE TABLESPACE  or  ALTER TABLESPACE  statement: The  AUTOEXTEND_SIZE  option can also be used when creating an undo tablespace, but the extension behavior for undo tablespaces differs. For more information, see Section 15.6.3.4, “Undo Tablespaces” . The  AUTOEXTEND_SIZE  setting must be a multiple of 4M. Specifying an  AUTOEXTEND_SIZE  setting that is not a multiple of 4M returns an error. The  AUTOEXTEND_SIZE  default setting is 0, which causes the tablespace to be extended according to the default behavior described above. The maximum  AUTOEXTEND_SIZE  setting is 64M in MySQL 8.0.23. From MySQL 8.0.24, the maximum setting is 4GB. The minimum  AUTOEXTEND_SIZE  setting depends on the  InnoDB  page size, as shown in the following table: Note ALTER TABLESPACE ts1 AUTOEXTEND_SIZE = 8M; CREATE TABLESPACE ts1 AUTOEXTEND_SIZE = 4M; ALTER TABLE t1 AUTOEXTEND_SIZE = 8M; CREATE TABLE t1 (c1 INT) AUTOEXTEND_SIZE = 4M; mysql>  SELECT @@GLOBAL.innodb_page_size; The default  InnoDB  page size is 16K (16384 bytes). To determine the  InnoDB  page size for your MySQL instance, query the  innodb_page_size  setting: 3071 InnoDB Page Size Minimum AUTOEXTEND_SIZE 4K 4M 8K 4M 16K 4M 32K 8M 64K 16M +---------------------------+ | @@GLOBAL.innodb_page_size | +---------------------------+ | 16384 | +---------------------------+