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_
tables. See , "Event Wait Summary Tables".
xxx