These views summarize the information in the
INNODB_BUFFER_PAGE table, grouped
by schema. By default, rows are sorted by descending buffer
Querying views that access the
INNODB_BUFFER_PAGE table can
affect performance. Do not query these views on a production
system unless you are aware of the performance impact and
have determined it to be acceptable. To avoid impacting
performance on a production system, reproduce the issue you
want to investigate and query buffer pool statistics on a
views have these columns:
The schema name for the object, or
InnoDB Systemif the table belongs to the
The total number of bytes allocated for the schema.
The total number of data bytes allocated for the schema.
The total number of pages allocated for the schema.
The total number of hashed pages allocated for the schema.
The total number of old pages allocated for the schema.
The total number of cached rows for the schema.