In the 5.6.4 release it is now possible to create an InnoDB
database with 4k or 8k page sizes in addition to the original 16k
page size. Previously, it could be done by recompiling the engine
with a different value for UNIV_PAGE_SIZE_SHIFT and
UNIV_PAGE_SIZE. With this release, you can set
–innodb-page-size=n when starting mysqld, or put
innodb_page_size=n in the configuration file in the [mysqld]
section where n can be 4k, 8k, 16k, or 4096, 8192, 16384.

The support of smaller page sizes may be useful for certain
storage media such as SSDs. Performance results can vary
depending on your data schema, record size, and read/write ratio.
But this provides you more options to optimize your performance.

When this new setting is used, the page size is set for all
tablespaces used by that InnoDB instance. You can query the
current value with;

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.