InnoDB page size

InnoDB page size

PREVIOUS POST
NEXT POST

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:

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.

PREVIOUS POST
NEXT POST

Share this post

Comments (5)

  • peter Reply

    Yes. Playing with different page sizes is good thing to try if you’re trying to get maximum performance. Too bad Innodb currently does not allow to specify it for table or index but it has to be global and requires server rebuild. Generally for certain OLTP workloads you might like to have smaller pages as these allow more distinct peices of data to be in buffer pool. For DSS workloads which require large scans or deal with large rows on the contrary large pages could be good to avoid fragmentation.

    June 4, 2006 at 11:27 am
  • MySQLBlog Reply

    Page Size and the Five-Minute Rule…

    As the years go by, data pages on disk have to get bigger. 16 KB pages were good for databases in the late 1990’s, but today’s data pages should probably be 64 KB. Page sizes go up over time because memory gets cheaper, and disks get much larger, b…

    July 21, 2008 at 9:09 pm
  • podarok Reply

    Are thehe any speed test with different sizes for it?

    October 3, 2011 at 8:34 am
  • Song Reply

    Hi Vadim Tkachenko,

    I like your idea but i cannot config because i don’t know where is this innobase/include/univ.i. I’m using Cent Os

    December 15, 2012 at 6:11 pm
  • jafar Reply

    Not able to find univ.i file, would you help

    June 30, 2014 at 10:20 am

Leave a Reply