As maybe you know InnoDB uses hard page size 16Kb for datafiles and for buffer pool.
However this size can be changed if you need it for your workload.
go to file innobase/include/univ.i, lines:
|
1 |
<br>/* The universal page size of the database */<br>#define UNIV_PAGE_SIZE (2 * 8192) /* NOTE! Currently, this has to be a<br> power of 2 */<br>/* The 2-logarithm of UNIV_PAGE_SIZE: */<br><br>#define UNIV_PAGE_SIZE_SHIFT 14<br> |
UNIV_PAGE_SIZE is page size (as you see – default value 16Kb). Possible values for UNIV_PAGE_SIZE is 8K, 16K, 32K, 64K. You also have to change UNIV_PAGE_SIZE_SHIFT (according comment it must be 2-logarithm of UNIV_PAGE_SIZE).
For pagesize 8K – UNIV_PAGE_SIZE_SHIFT=13, for 32K – UNIV_PAGE_SIZE_SHIFT=15 and so on.
