innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Sys Schema Views
These views summarize InnoDB buffer pool usage, showing the amount of memory and number of pages allocated to each database schema.
Querying these views can have a noticeable performance impact on a production server.
The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema views summarize information from the , grouped by schema. Rows are sorted by descending buffer size by default.
The innodb_buffer_stats_by_schema view is intended to be easier for human reading, while the x$innodb_buffer_stats_by_schema view provides the data in raw form, intended for tools that process the data.
They contain the following columns:
This page is licensed: CC BY-SA / Gnu FDL