Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 38.0Mb
PDF (A4) - 38.0Mb
PDF (RPM) - 37.3Mb
HTML Download (TGZ) - 10.3Mb
HTML Download (Zip) - 10.3Mb
HTML Download (RPM) - 8.9Mb
Man Pages (TGZ) - 216.8Kb
Man Pages (Zip) - 329.6Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

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

26.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.


User Comments
Sign Up Login You must be logged in to post a comment.