21.9.8.4. Object Wait Summary Table

The objects_summary_global_by_type aggregates object wait events. For example:

mysql> SELECT * FROM
        objects_summary_global_by_type\G...*************************** 3. row ***************************   OBJECT_TYPE: TABLE OBJECT_SCHEMA: test   OBJECT_NAME: t    COUNT_STAR: 3SUM_TIMER_WAIT: 263126976MIN_TIMER_WAIT: 1522272AVG_TIMER_WAIT: 87708678MAX_TIMER_WAIT: 258428280...*************************** 10. row ***************************   OBJECT_TYPE: TABLE OBJECT_SCHEMA: mysql   OBJECT_NAME: user    COUNT_STAR: 14SUM_TIMER_WAIT: 365567592MIN_TIMER_WAIT: 1141704AVG_TIMER_WAIT: 26111769MAX_TIMER_WAIT: 334783032...

TRUNCATE TABLE is permitted for object summary tables. It resets the counters to zero rather than removing rows.

The objects_summary_global_by_type table has these grouping columns to indicate how events are aggregated: OBJECT_TYPE, OBJECT_SCHEMA, and OBJECT_NAME. Each row summarizes events for the given object.

objects_summary_global_by_type has the same summary columns as the events_waits_summary_by_xxx tables. See Section 21.9.8.1, "Event Wait Summary Tables".