Table Options

Table options are used to optimize the behavior of a table.

CREATE [...] tbl_name (create_definition, ...) [table_options]

ALTER [...] TABLE tbl_name [alter_specification [, alter_specification] ...]

alter_specification:
    table_options
  | ADD [...]

table_options:
    table_option [[,] table_option] ...]

table_option:
    MIN_PAGES [=] value
  | [...]

The table_option rule signifies a table option of the kind that can be used in a CREATE TABLE or ALTER TABLE statement.

• MIN_PAGES

  In the case of a CREATE TABLE statement, MIN_PAGES specifies the initial size, in pages, of InnoDB per-table tablespaces. In the case of an ALTER TABLE statement, MIN_PAGES extends the tablespace to the desired size. If the tablespace is large enough already, nothing changes. In order to retain forward compatibility in FRM files, MIN_PAGES is implemented as an alias for MIN_ROWS. Using MIN_ROWS has the same effect as MIN_PAGES. If the MIN_PAGES option is used in a CREATE TABLE statement that is logged to the binary log, the MIN_PAGES option is also used in the statement that is sent to slaves. The option is only meaningful if innodb_file_per_table is enabled.