My Oracle Support Banner

How to Use the Information Schema INNODB_BUFFER_PAGE Table? MySQL Enterprise Monitor (MEM) InnoDB Buffer Pool Usage Report (Doc ID 1933467.1)

Last updated on FEBRUARY 27, 2020

Applies to:

MySQL Enterprise Monitor - Version 3.0 and later
MySQL Server - Version 5.1 and later
Information in this document applies to any platform.

Purpose

Understand how to use the INNODB_BUFFER_PAGE table in the Information Schema to get information about the content of the InnoDB Buffer Pool.

Scope

Detailed general guidance for DBAs already familiar with the InnoDB Buffer Pool seeking guidance on how to use the INNODB_BUFFER_PAGE table to get information about the content of the InnoDB Buffer Pool.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Purpose
Scope
Details
 Availability
 The InnoDB Buffer Pool Overview
 System Data
 Index Data
 Table Data
 Calculating Amount of Data
 Deleted Data and Free Space in Pages
 Deleting rows from a table and free space in pages
 Dropping a table, partition, or index
 The MySQL Enterprise Monitor InnoDB Buffer Pool Usage Report
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.