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: 3
SUM_TIMER_WAIT: 263126976
MIN_TIMER_WAIT: 1522272
AVG_TIMER_WAIT: 87708678
MAX_TIMER_WAIT: 258428280
...
*************************** 10. row ***************************
 OBJECT_TYPE: TABLE
 OBJECT_SCHEMA: mysql
 OBJECT_NAME: user
 COUNT_STAR: 14
SUM_TIMER_WAIT: 365567592
MIN_TIMER_WAIT: 1141704
AVG_TIMER_WAIT: 26111769
MAX_TIMER_WAIT: 334783032
...

TRUNCATE TABLE is permitted for 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 , "Event Wait Summary Tables".

Retornar