Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.9Mb
PDF (A4) - 37.9Mb
PDF (RPM) - 37.2Mb
HTML Download (TGZ) - 10.2Mb
HTML Download (Zip) - 10.3Mb
HTML Download (RPM) - 8.9Mb
Man Pages (TGZ) - 214.6Kb
Man Pages (Zip) - 327.5Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

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

26.4.3.48 The wait_classes_global_by_avg_latency and x$wait_classes_global_by_avg_latency Views

These views summarize wait class average latencies, grouped by event class. By default, rows are sorted by descending average latency. Idle events are ignored.

An event class is determined by stripping from the event name everything after the first three components. For example, the class for wait/io/file/sql/slow_log is wait/io/file.

The wait_classes_global_by_avg_latency and x$wait_classes_global_by_avg_latency views have these columns:

  • event_class

    The event class.

  • total

    The total number of occurrences of events in the class.

  • total_latency

    The total wait time of timed occurrences of events in the class.

  • min_latency

    The minimum single wait time of timed occurrences of events in the class.

  • avg_latency

    The average wait time per timed occurrence of events in the class.

  • max_latency

    The maximum single wait time of timed occurrences of events in the class.


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