This table aggregates usage statistics for objects (tables, events, etc.) by type, schema, and name, showing global access counts and timers.
It aggregates object wait events, and contains the following columns:
OBJECT_TYPE
Groups records together with OBJECT_SCHEMA and OBJECT_NAME.
OBJECT_SCHEMA
Groups records together with OBJECT_TYPE and OBJECT_NAME.
OBJECT_NAME
Groups records together with OBJECT_SCHEMA and OBJECT_TYPE.
COUNT_STAR
Number of summarized events
You can the table, which will reset all counters to zero.
This page is licensed: CC BY-SA / Gnu FDL
SUM_TIMER_WAIT
Total wait time of the summarized events that are timed.
MIN_TIMER_WAIT
Minimum wait time of the summarized events that are timed.
AVG_TIMER_WAIT
Average wait time of the summarized events that are timed.
MAX_TIMER_WAIT
Maximum wait time of the summarized events that are timed.
SELECT * FROM objects_summary_global_by_type\G
...
*************************** 101. row ***************************
OBJECT_TYPE: TABLE
OBJECT_SCHEMA: test
OBJECT_NAME: v
COUNT_STAR: 0
SUM_TIMER_WAIT: 0
MIN_TIMER_WAIT: 0
AVG_TIMER_WAIT: 0
MAX_TIMER_WAIT: 0
*************************** 102. row ***************************
OBJECT_TYPE: TABLE
OBJECT_SCHEMA: test
OBJECT_NAME: xx2
COUNT_STAR: 2
SUM_TIMER_WAIT: 1621920
MIN_TIMER_WAIT: 481344
AVG_TIMER_WAIT: 810960
MAX_TIMER_WAIT: 1140576