Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 44.6Mb
PDF (A4) - 44.7Mb
PDF (RPM) - 40.4Mb
HTML Download (TGZ) - 10.5Mb
HTML Download (Zip) - 10.5Mb
HTML Download (RPM) - 9.1Mb
Man Pages (TGZ) - 205.6Kb
Man Pages (Zip) - 308.8Kb
Info (Gzip) - 3.9Mb
Info (Zip) - 3.9Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  ...  /  The io_global_by_file_by_latency and x$io_global_by_file_by_latency Views

27.4.3.12 The io_global_by_file_by_latency and x$io_global_by_file_by_latency Views

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.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.