innoDB uses hard page size 16Kb for datafiles and for buffer
pool.
在如下地方更改:
go to file innobase/include/univ.i, lines:
#define UNIV_PAGE_SIZE (2 * 8192)
#define UNIV_PAGE_SIZE_SHIFT 14
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.
效果:
对Innodb表空间page size大小有效