系统表介绍
objects_summary_global_by_type 包含了按对象统计的事件对象
| 列名 | 含义 |
|---|---|
| OBJECT_TYPE | 对象类型 |
| OBJECT_SCHEMA | 对象所属模式 |
| OBJECT_NAME | 对象名称 |
| COUNT_STAR | 事件汇总数 |
| SUM_TIMER_WAIT | 事件总等待时间 |
| MIN_TIMER_WAIT | 事件最小等待时间 |
| AVG_TIMER_WAIT | 事件平均等待时间 |
| MAX_TIMER_WAIT | 事件最大等待时间 |
实例
mysql> select * from objects_summary_global_by_type where count_star > 0 limit 2 \G;
*************************** 1. row ***************************
OBJECT_TYPE: TABLE
OBJECT_SCHEMA: daozhang
OBJECT_NAME: it_task
COUNT_STAR: 6
SUM_TIMER_WAIT: 1388581536
MIN_TIMER_WAIT: 2310520
AVG_TIMER_WAIT: 231430256
MAX_TIMER_WAIT: 1134407040
*************************** 2. row ***************************
OBJECT_TYPE: TABLE
OBJECT_SCHEMA: daozhang
OBJECT_NAME: it_user
COUNT_STAR: 19
SUM_TIMER_WAIT: 1127634904
MIN_TIMER_WAIT: 1341192
AVG_TIMER_WAIT: 59348968
MAX_TIMER_WAIT: 811020720
2 rows in set (0.01 sec)