25.12.15.5 对象 await 摘要 table

性能架构维护objects_summary_global_by_typetable,以聚合对象 await 事件。

示例对象 await 事件摘要信息:

mysql> SELECT * FROM performance_schema.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
...

objects_summary_global_by_typetable 具有以下分组列,以指示该 table 如何聚合事件:OBJECT_TYPEOBJECT_SCHEMAOBJECT_NAME。每行总结了给定对象的事件。

objects_summary_global_by_typeevents_waits_summary_by_xxxtable 具有相同的摘要列。参见第 25.12.15.1 节,“await 事件摘要 table”

对象摘要 table 允许TRUNCATE TABLE。它将摘要列重置为零,而不是删除行。