Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.1Mb
PDF (A4) - 43.2Mb
Man Pages (TGZ) - 295.4Kb
Man Pages (Zip) - 400.6Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

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

30.4.3.13 The io_global_by_wait_by_bytes and x$io_global_by_wait_by_bytes Views

These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. By default, rows are sorted by descending total I/O (bytes read and written).

The io_global_by_wait_by_bytes and x$io_global_by_wait_by_bytes views have these columns:

  • event_name

    The I/O event name, with the wait/io/file/ prefix stripped.

  • total

    The total number of occurrences of the I/O event.

  • total_latency

    The total wait time of timed occurrences of the I/O event.

  • min_latency

    The minimum single wait time of timed occurrences of the I/O event.

  • avg_latency

    The average wait time per timed occurrence of the I/O event.

  • max_latency

    The maximum single wait time of timed occurrences of the I/O event.

  • count_read

    The number of read requests for the I/O event.

  • total_read

    The number of bytes read for the I/O event.

  • avg_read

    The average number of bytes per read for the I/O event.

  • count_write

    The number of write requests for the I/O event.

  • total_written

    The number of bytes written for the I/O event.

  • avg_written

    The average number of bytes per write for the I/O event.

  • total_requested

    The total number of bytes read and written for the I/O event.