io_global_by_wait_by_bytes and x$io_global_by_wait_by_bytes Sys Schema Views
MariaDB starting with 10.6
These Sys Schema views were introduced in MariaDB 10.6.
Description
The io_global_by_wait_by_bytes and x$io_global_by_wait_by_bytes views summarize global I/O consumers, displaying amount of I/O and time waiting for I/O, grouped by event. Rows are sorted by descending total I/O (bytes read and written) by default.
The io_global_by_wait_by_bytes view is intended to be easier for human reading, while the x$io_global_by_wait_by_bytes view provides the data in raw form, intended for tools that process the data.
They contain the following columns:
| Column | Description |
|---|---|
| event_name | I/O event name. The wait/io/file prefix is stripped. |
| total | Total number of occurrences of the I/O event. |
| total_latency | Total wait time of timed occurrences of the I/O event |
| min_latency | Minimum single wait time of timed occurrences of the I/O event. |
| avg_latency | Average wait time per timed occurrence of the I/O event. |
| max_latency | Maximum single wait time of timed occurrences of the I/O event. |
| count_read | Total number of read I/O events for the file. |
| total_read | Total number of bytes read for the I/O event. |
| avg_read | Average number of bytes per read for the I/O event. |
| count_write | Total number of write requests for the I/O event. |
| total_written | Number of bytes written for the I/O event. |
| avg_written | Average number of bytes per write for the I/O event. |
| total_requested | Total number of bytes (read and write) for the I/O event. |
Example
SELECT * FROM sys.io_global_by_wait_by_bytes\G
*************************** 1. row ***************************
event_name: innodb/innodb_data_file
total: 220
total_latency: 38.96 ms
min_latency: 0 ps
avg_latency: 177.09 us
max_latency: 4.07 ms
count_read: 174
total_read: 4.73 MiB
avg_read: 27.86 KiB
count_write: 0
total_written: 0 bytes
avg_written: 0 bytes
total_requested: 4.73 MiB
*************************** 2. row ***************************
event_name: aria/MAD
total: 1107
total_latency: 18.27 ms
min_latency: 0 ps
avg_latency: 16.50 us
max_latency: 204.97 us
count_read: 105
total_read: 840.00 KiB
avg_read: 8.00 KiB
count_write: 0
total_written: 0 bytes
avg_written: 0 bytes
total_requested: 840.00 KiB
...
SELECT * FROM sys.x$io_global_by_wait_by_bytes\G
*************************** 1. row ***************************
event_name: innodb/innodb_data_file
total: 220
total_latency: 38959722138
min_latency: 0
avg_latency: 177089374
max_latency: 4065566778
count_read: 174
total_read: 4964352
avg_read: 28530.7586
count_write: 0
total_written: 0
avg_written: 0.0000
total_requested: 4964352
*************************** 2. row ***************************
event_name: aria/MAD
total: 1107
total_latency: 18270683624
min_latency: 0
avg_latency: 16504546
max_latency: 204973168
count_read: 105
total_read: 860160
avg_read: 8192.0000
count_write: 0
total_written: 0
avg_written: 0.0000
total_requested: 860160
...
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.
