host_summary_by_file_io and x$host_summary_by_file_io Sys Schema Views
You are viewing an old version of this article. View
the current version here.
MariaDB starting with 10.6
These Sys Schema views were introduced in MariaDB 10.6
Description
The host_summary_by_file_io
and x$host_summary_by_file_io
views summarize file I/O, grouped by host. Rows are sorted by descending total file I/O latency by default.
The host_summary_by_file_io
view is intended to be easier for human reading, while the and
x$host_summary_by_file_io view provides the data in raw form, intended for tools that process the data.
They contain the following columns:
Column | Description |
---|---|
host | Host that the client connected from, or background for background threads (where the HOST column in the underlying Performance Schema table is NULL). |
ios | Total file I/O events for the host. |
ios_latency | Total wait time of timed file I/O events for the host. |
Example
SELECT * FROM sys.host_summary_by_file_io\G *************************** 1. row *************************** host: localhost ios: 6526 io_latency: 490.28 ms *************************** 2. row *************************** host: background ios: 457 io_latency: 151.39 ms SELECT * FROM sys.x$host_summary_by_file_io\G *************************** 1. row *************************** host: localhost ios: 6532 io_latency: 490447878974 *************************** 2. row *************************** host: background ios: 457 io_latency: 151388125856
Comments
Comments loading...
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.