io_by_thread_by_latency and x$io_by_thread_by_latency Sys Schema Views - Source

Revision: 143370
User: Ian Gilfillan
Date: 2024-09-17 16:01

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

== 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:

== Example
<<code>>
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

...
<</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.

io_by_thread_by_latency and x$io_by_thread_by_latency Sys Schema Views - Source

Products

Services

Pricing

Resources

About Us

Download MariaDB