Skip to content

The INNODB_BUFFER_PAGE table

darnaut edited this page Nov 15, 2012 · 6 revisions

The INNODB_BUFFER_PAGE table holds information about each page in the InnoDB buffer pool. Twitter MySQL supports the following additional columns.

Column name Description
LEVEL The level of an index page in the B-tree.
DIRECTION Direction of inserts into an index page (e.g. "LEFT", "RIGHT", "NO_DIRECTION" or NULL).
N_DIRECTION Number of consecutive inserts in the same direction.