Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 47.0Mb
PDF (A4) - 47.0Mb
PDF (RPM) - 42.4Mb
HTML Download (TGZ) - 10.8Mb
HTML Download (Zip) - 10.9Mb
HTML Download (RPM) - 9.4Mb
Man Pages (TGZ) - 227.0Kb
Man Pages (Zip) - 333.7Kb
Info (Gzip) - 4.2Mb
Info (Zip) - 4.2Mb
Excerpts from this Manual

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

27.4.3.11 The io_global_by_file_by_bytes and x$io_global_by_file_by_bytes Views

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

The io_global_by_file_by_bytes and x$io_global_by_file_by_bytes views have these columns:

  • file

    The file path name.

  • count_read

    The total number of read events for the file.

  • total_read

    The total number of bytes read from the file.

  • avg_read

    The average number of bytes per read from the file.

  • count_write

    The total number of write events for the file.

  • total_written

    The total number of bytes written to the file.

  • avg_write

    The average number of bytes per write to the file.

  • total

    The total number of bytes read and written for the file.

  • write_pct

    The percentage of total bytes of I/O that were writes.