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

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

mysql> SELECT * FROM performance_schemaobjects_summary_global_by_type \ G…*************************** 3所示。行*************************** OBJECT_TYPE:表OBJECT_SCHEMA:测试OBJECT_NAME: t COUNT_STAR: 3 SUM_TIMER_WAIT: 263126976 MIN_TIMER_WAIT: 1522272 AVG_TIMER_WAIT: 87708678 MAX_TIMER_WAIT: 258428280…*************************** 10。行*************************** OBJECT_TYPE:表OBJECT_SCHEMA: mysql OBJECT_NAME:用户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_TYPE，OBJECT_SCHEMA,OBJECT_NAME．每行总结给定对象的事件。

objects_summary_global_by_type的摘要列与events_waits_summary_by_xxx表。看到第27.12.20.1节“等待事件汇总表”．

的objects_summary_global_by_type表中有这些索引:

截断表允许用于对象汇总表。它将汇总列重置为零，而不是删除行。