innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Sys Schema Views - Source

Revision: 143369
User: Ian Gilfillan
Date: 2024-09-17 14:59

<<product mariadb from=10.6>>
These [[sys-schema|Sys Schema]] views were introduced in MariaDB 10.6.
<</product>>

<<style class="redbox">>
Querying these views can have a noticeable performance impact on a production server.
<</style>>

== Description

The ##innodb_buffer_stats_by_schema## and ##x$innodb_buffer_stats_by_schema## views summarize information from the [[information-schema-innodb_buffer_page-table/|Information Schema INNODB_BUFFER_PAGE table]], 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:

== Example
<<code>>
SELECT * FROM sys.innodb_buffer_stats_by_schema\G
*************************** 1. row ***************************
object_schema: InnoDB System
    allocated: 160.00 KiB
         data: 6.21 KiB
        pages: 10
 pages_hashed: 10
    pages_old: 10
  rows_cached: 21
*************************** 2. row ***************************
object_schema: mysql
    allocated: 112.00 KiB
         data: 1.73 KiB
        pages: 7
 pages_hashed: 7
    pages_old: 7
  rows_cached: 5
*************************** 3. row ***************************
object_schema: test
    allocated: 64.00 KiB
         data: 0 bytes
        pages: 4
 pages_hashed: 4
    pages_old: 4
  rows_cached: 0

SELECT * FROM sys.x$innodb_buffer_stats_by_schema\G
*************************** 1. row ***************************
object_schema: InnoDB System
    allocated: 163840
         data: 6362
        pages: 10
 pages_hashed: 0
    pages_old: 0
  rows_cached: 21
*************************** 2. row ***************************
object_schema: mysql
    allocated: 114688
         data: 1775
        pages: 7
 pages_hashed: 0
    pages_old: 0
  rows_cached: 5
*************************** 3. row ***************************
object_schema: test
    allocated: 65536
         data: 0
        pages: 4
 pages_hashed: 0
    pages_old: 0
  rows_cached: 0
<</code>>

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Sys Schema Views - Source

Products

Services

Pricing

Resources

About Us

Download MariaDB