objects_summary_global_by_type表

• 对象等待事件摘要表只包含一张表，即objects_summary_global_by_type，该表按照OBJECT_TYPE、OBJECT_SCHEMA、OBJECT_NAME字段进行分组，聚合字段与3.14.1.小节的等待事件摘要表聚合字段相同，含义相同

  • objects_summary_global_by_type按照OBJECT_TYPE、OBJECT_SCHEMA、OBJECT_NAME列进行分组
  • objects_summary_global_by_type与events_waits_summary_by_xxx表按照相同的聚合列进行聚合相关事件信息

• 对象摘要表允许使用TRUNCATE TABLE语句。但只将聚合列重置为零，而不是删除行

• 表记录内容示例

admin@localhost : performance_schema 11:10:42> select * from objects_summary_global_by_type where SUM_TIMER_WAIT!=0\G;
*************************** 1. row ***************************
  OBJECT_TYPE: TABLE
OBJECT_SCHEMA: xiaoboluo
  OBJECT_NAME: test
    COUNT_STAR: 56
SUM_TIMER_WAIT: 195829830101250
MIN_TIMER_WAIT: 2971125
AVG_TIMER_WAIT: 3496961251500
MAX_TIMER_WAIT: 121025235946125
1 row in set (0.00 sec)

• 表结构定义

CREATE TABLE `objects_summary_global_by_type` (
  `OBJECT_TYPE` varchar(64) DEFAULT NULL,
  `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
  `OBJECT_NAME` varchar(64) DEFAULT NULL,
  `COUNT_STAR` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8

• 参考链接：https://dev.mysql.com/doc/refman/5.7/en/objects-summary-global-by-type-table.html

---

上一篇： events_transactions_summary_*表 | 下一篇： file_summary_*表