MySQL 9.0 Reference Manual Including MySQL NDB Cluster 9.0
These views summarize global I/O consumers to display time waiting for I/O, grouped by file. By default, rows are sorted by descending total latency.
The io_global_by_file_by_latency
and
x$io_global_by_file_by_latency
views have these columns:
file
The file path name.
total
The total number of I/O events for the file.
total_latency
The total wait time of timed I/O events for the file.
count_read
The total number of read I/O events for the file.
read_latency
The total wait time of timed read I/O events for the file.
count_write
The total number of write I/O events for the file.
write_latency
The total wait time of timed write I/O events for the file.
count_misc
The total number of other I/O events for the file.
misc_latency
The total wait time of timed other I/O events for the file.