184.108.40.206 The innodb_buffer_stats_by_table and x$innodb_buffer_stats_by_table Views
These views summarize the information in the
INNODB_BUFFER_PAGE table, grouped by schema and table. By default, rows are sorted by descending buffer size.
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 test instance.
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.