对象等待摘要表
性能架构维护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_TYPE
,OBJECT_SCHEMA
,和OBJECT_NAME
。每行总结了给定对象的事件。
objects_summary_global_by_type
与表格具有相同的摘要列。请参见“等待事件摘要表”。events_waits_summary_by_xxx
该objects_summary_global_by_type
表具有以下索引:
- 在主键(
OBJECT_TYPE
,OBJECT_SCHEMA
,OBJECT_NAME
)
TRUNCATE TABLE
允许用于对象摘要表。它将摘要列重置为零,而不是删除行。