mysql 数据页_mysql数据页大小

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大小有效