Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.9Mb
PDF (A4) - 37.9Mb
PDF (RPM) - 36.5Mb
HTML Download (TGZ) - 9.9Mb
HTML Download (Zip) - 9.9Mb
HTML Download (RPM) - 8.7Mb
Man Pages (TGZ) - 209.5Kb
Man Pages (Zip) - 318.7Kb
Info (Gzip) - 3.5Mb
Info (Zip) - 3.5Mb
Excerpts from this Manual

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

26.4.3.10 The io_by_thread_by_latency and x$io_by_thread_by_latency Views

These views summarize I/O consumers to display time waiting for I/O, grouped by thread. By default, rows are sorted by descending total I/O latency.

The io_by_thread_by_latency and x$io_by_thread_by_latency views have these columns:

  • user

    For foreground threads, the account associated with the thread. For background threads, the thread name.

  • total

    The total number of I/O events for the thread.

  • total_latency

    The total wait time of timed I/O events for the thread.

  • min_latency

    The minimum single wait time of timed I/O events for the thread.

  • avg_latency

    The average wait time per timed I/O event for the thread.

  • max_latency

    The maximum single wait time of timed I/O events for the thread.

  • thread_id

    The thread ID.

  • processlist_id

    For foreground threads, the processlist ID of the thread. For background threads, NULL.


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.