MySQL 9.4 Release Notes
These views summarize I/O consumers to display time waiting for I/O, grouped by thread. By default, rows are sorted by descending total I/O latency.
The io_by_thread_by_latency and
x$io_by_thread_by_latency views
have these columns:
userFor foreground threads, the account associated with the thread. For background threads, the thread name.
totalThe total number of I/O events for the thread.
total_latencyThe total wait time of timed I/O events for the thread.
min_latencyThe minimum single wait time of timed I/O events for the thread.
avg_latencyThe average wait time per timed I/O event for the thread.
max_latencyThe maximum single wait time of timed I/O events for the thread.
thread_idThe thread ID.
processlist_idFor foreground threads, the processlist ID of the thread. For background threads,
NULL.