content_image/692794.jpg content_image/692795.jpg content_image/692796.jpg content_image/692797.jpg
•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: 

CREATE TABLE t1 (c1 INT) AUTOEXTEND_SIZE = 4M; 

ALTER TABLE t1 AUTOEXTEND_SIZE = 8M; 

To configure the extension size for a general tablespace, specify the AUTOEXTEND_SIZE  size in a CREATE TABLESPACE  or ALTER TABLESPACE  statement: 

CREATE TABLESPACE ts1 AUTOEXTEND_SIZE = 4M; 

ALTER TABLESPACE ts1 AUTOEXTEND_SIZE = 8M; 

<img src='content_image/692794.jpg'>

<img src='content_image/692795.jpg'>

## Note 

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: 

<img src='content_image/692796.jpg'>

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: 

mysql> SELECT @@GLOBAL.innodb_page_size; 

<img src='content_image/692797.jpg'>

