host_summary_by_file_io_type and x$host_summary_by_file_io_type Sys Schema Views - Source

Revision: 143357
User: Ian Gilfillan
Date: 2024-09-17 13:05

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

== Description

The ##host_summary_by_file_io_type## and ##x$host_summary_by_file_io_type## views summarize file I/O, grouped by host and event type. Rows are sorted by host and descending total I/O latency by default.  The ##host_summary_by_file_io_type## view is intended to be easier for human reading, while the ##x$host_summary_by_file_io_type## view provides the data in raw form, intended for tools that process the data.

They contain the following columns:

== Example
<<code>>
SELECT * FROM sys.host_summary_by_file_io_type;
+------------+----------------------------------------------+-------+---------------+-------------+
| host       | event_name                                   | total | total_latency | max_latency |
+------------+----------------------------------------------+-------+---------------+-------------+
| background | wait/io/file/innodb/innodb_log_file          |    45 | 109.80 ms     | 26.48 ms    |
| background | wait/io/file/innodb/innodb_data_file         |   195 | 29.47 ms      | 1.23 ms     |
| background | wait/io/file/sql/global_ddl_log              |     4 | 4.45 ms       | 4.33 ms     |
...
| localhost  | wait/io/file/csv/data                        |     4 | 25.98 us      | 9.60 us     |
| localhost  | wait/io/file/partition/ha_partition::parfile |     1 | 14.19 us      | 14.19 us    |
| localhost  | wait/io/file/myisam/kfile                    |     1 | 11.95 us      | 11.95 us    |
+------------+----------------------------------------------+-------+---------------+-------------+

SELECT * FROM sys.x$host_summary_by_file_io_type;
+------------+----------------------------------------------+-------+---------------+-------------+
| host       | event_name                                   | total | total_latency | max_latency |
+------------+----------------------------------------------+-------+---------------+-------------+
| background | wait/io/file/innodb/innodb_log_file          |    45 |  109804643160 | 26478157582 |
| background | wait/io/file/innodb/innodb_data_file         |   195 |   29469738630 |  1226986584 |
| background | wait/io/file/sql/global_ddl_log              |     4 |    4447263252 |  4327780456 |
| localhost  | wait/io/file/csv/data                        |     4 |      25978718 |     9603922 |
| localhost  | wait/io/file/partition/ha_partition::parfile |     1 |      14191190 |    14191190 |
| localhost  | wait/io/file/myisam/kfile                    |     1 |      11954300 |    11954300 |
+------------+----------------------------------------------+-------+---------------+-------------+
<</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.

host_summary_by_file_io_type and x$host_summary_by_file_io_type Sys Schema Views - Source

Products

Solutions

Resources

Company

Pricing

Download MariaDB