io_by_thread_by_latency and x$io_by_thread_by_latency 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 io_by_thread_by_latency
and x$io_by_thread_by_latency
view summarize I/O consumers to display time waiting for I/O, grouped by thread. Rows are sorted by descending total I/O latency by default.
The io_by_thread_by_latency
view is intended to be easier for human reading, while the x$io_by_thread_by_latency
view provides the data in raw form, intended for tools that process the data.
They contain the following columns:
Column | Description |
---|---|
user | The account associated with a foreground thread, or the background thread name |
total | Total number of I/O events allocated for the thread. |
total_latency | Total wait time of timed I/O events for the thread. |
min_latency | Minimum single wait time of timed I/O events for the thread. |
avg_latency | Average wait time per timed I/O event for the thread. |
min_latency | Maximum single wait time of timed I/O events for the thread. |
thread_id | Thread id. |
processlist_id | Processlist id for foreground threads, or NULL for background threads. |
Example
SELECT * FROM sys.io_by_thread_by_latency\G *************************** 1. row *************************** user: main total: 378 total_latency: 40.11 ms min_latency: 570.21 ns avg_latency: 206.02 us max_latency: 4.33 ms thread_id: 1 processlist_id: NULL *************************** 2. row *************************** user: msandbox@localhost total: 521 total_latency: 10.28 ms min_latency: 775.04 ns avg_latency: 21.79 us max_latency: 977.79 us thread_id: 89 processlist_id: 7 ... SELECT * FROM sys.x$io_by_thread_by_latency\G *************************** 1. row *************************** user: main total: 378 total_latency: 40106340880 min_latency: 570208 avg_latency: 206016046.6000 max_latency: 4327780456 thread_id: 1 processlist_id: NULL *************************** 2. row *************************** user: msandbox@localhost total: 498 total_latency: 9637694714 min_latency: 775040 avg_latency: 21364289.0000 max_latency: 977787350 thread_id: 89 processlist_id: 7 ...
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.