系统表介绍
events_transactions_summary_by_user_by_event_name 反映了事务级事件按用事件进行分组统计
| 列名 | 含义 |
|---|---|
| EVENT_NAME | 事件名称 |
| COUNT_STAR | 事件汇总数 |
| SUM_TIMER_WAIT | 事件总等待时间 |
| MIN_TIMER_WAIT | 事件最小等待时间 |
| AVG_TIMER_WAIT | 事件平均等待时间 |
| MAX_TIMER_WAIT | 事件最大等待时间 |
| COUNT_READ_WRITE | 读写事务的事件总数 |
| SUM_TIMER_READ_WRITE | 读写事务的总等待时间 |
| MIN_TIMER_READ_WRITE | 读写事务的最小等待时间 |
| AVG_TIMER_READ_WRITE | 读写事务的平均等待时间 |
| MAX_TIMER_READ_WRITE | 读写事务的最大等待时间 |
| COUNT_READ_ONLY | 只读事务的事件总数 |
| SUM_TIMER_READ_ONLY | 只读事务的总等待时间 |
| MIN_TIMER_READ_ONLY | 只读事务的最小等待时间 |
| AVG_TIMER_READ_ONLY | 只读事务的平均等待时间 |
| MAX_TIMER_READ_ONLY | 只读事务的最大等待时间 |
实例
mysql> select * from events_transactions_summary_global_by_event_name limit 2 \G;
*************************** 1. row ***************************
EVENT_NAME: transaction
COUNT_STAR: 8
SUM_TIMER_WAIT: 242154022995049000
MIN_TIMER_WAIT: 2064026000
AVG_TIMER_WAIT: 30269252874381000
MAX_TIMER_WAIT: 152879566771852000
COUNT_READ_WRITE: 7
SUM_TIMER_READ_WRITE: 242154020931023000
MIN_TIMER_READ_WRITE: 33093499108000
AVG_TIMER_READ_WRITE: 34593431561574000
MAX_TIMER_READ_WRITE: 152879566771852000
COUNT_READ_ONLY: 1
SUM_TIMER_READ_ONLY: 2064026000
MIN_TIMER_READ_ONLY: 2064026000
AVG_TIMER_READ_ONLY: 2064026000
MAX_TIMER_READ_ONLY: 2064026000
1 row in set (0.01 sec)