Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 44.6Mb
PDF (A4) - 44.7Mb
PDF (RPM) - 40.4Mb
HTML Download (TGZ) - 10.5Mb
HTML Download (Zip) - 10.5Mb
HTML Download (RPM) - 9.1Mb
Man Pages (TGZ) - 205.6Kb
Man Pages (Zip) - 308.8Kb
Info (Gzip) - 3.9Mb
Info (Zip) - 3.9Mb
Excerpts from this Manual

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

27.4.3.49 The wait_classes_global_by_latency and x$wait_classes_global_by_latency Views

These views summarize wait class total latencies, grouped by event class. By default, rows are sorted by descending total 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_latency and x$wait_classes_global_by_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
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.