Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.9Mb
PDF (A4) - 38.0Mb
PDF (RPM) - 36.5Mb
HTML Download (TGZ) - 9.9Mb
HTML Download (Zip) - 9.9Mb
HTML Download (RPM) - 8.7Mb
Man Pages (TGZ) - 210.0Kb
Man Pages (Zip) - 319.1Kb
Info (Gzip) - 3.5Mb
Info (Zip) - 3.5Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  ...  /  The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Views

26.4.3.7 The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Views

These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema. By default, rows are sorted by descending buffer size.

Warning

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 innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema views have these columns:

  • object_schema

    The schema name for the object, or InnoDB System if the table belongs to the InnoDB storage engine.

  • allocated

    The total number of bytes allocated for the schema.

  • data

    The total number of data bytes allocated for the schema.

  • pages

    The total number of pages allocated for the schema.

  • pages_hashed

    The total number of hashed pages allocated for the schema.

  • pages_old

    The total number of old pages allocated for the schema.

  • rows_cached

    The total number of cached rows for the schema.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.