Documentation Home

27.12.20.6 对象等待汇总表

性能模式维护 objects_summary_global_by_type 用于聚合对象等待事件的表。

示例对象等待事件摘要信息:

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_type 表具有这些分组列以指示该表如何聚合事件:OBJECT_TYPEOBJECT_SCHEMAOBJECT_NAME。每行总结给定对象的事件。

objects_summary_global_by_type 具有与表相同的摘要列 。请参阅 第 27.12.20.1 节,“等待事件摘要表”events_waits_summary_by_xxx

objects_summary_global_by_type 表具有以下索引:

  • OBJECT_TYPE( , OBJECT_SCHEMA, OBJECT_NAME) 上的主键

TRUNCATE TABLE对于对象汇总表是允许的。它将汇总列重置为零而不是删除行。