Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.1Mb
PDF (A4) - 43.2Mb
Man Pages (TGZ) - 295.4Kb
Man Pages (Zip) - 400.6Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

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

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