These views summarize the information in the
INNODB_BUFFER_PAGE table, grouped
by schema and table. By default, rows are sorted by descending
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 table name.
The total number of bytes allocated for the table.
The number of data bytes allocated for the table.
The total number of pages allocated for the table.
The number of hashed pages allocated for the table.
The number of old pages allocated for the table.
The number of cached rows for the table.