系统表介绍
events_transactions_summary_by_user_by_event_name 反映了事务级事件按用同户名与事件分组统计
列名 | 含义 |
---|---|
USER | 用户名 |
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_by_user_by_event_name where user is not null limit 2 \G;
*************************** 1. row ***************************
USER: root
EVENT_NAME: transaction
COUNT_STAR: 3
SUM_TIMER_WAIT: 153612084520379000
MIN_TIMER_WAIT: 2064026000
AVG_TIMER_WAIT: 51204028173459000
MAX_TIMER_WAIT: 152879566771852000
COUNT_READ_WRITE: 2
SUM_TIMER_READ_WRITE: 153612082456353000
MIN_TIMER_READ_WRITE: 732515684501000
AVG_TIMER_READ_WRITE: 76806041228176000
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
*************************** 2. row ***************************
USER: dao
EVENT_NAME: transaction
COUNT_STAR: 5
SUM_TIMER_WAIT: 88541938474670000
MIN_TIMER_WAIT: 33093499108000
AVG_TIMER_WAIT: 17708387694934000
MAX_TIMER_WAIT: 44223119349124000
COUNT_READ_WRITE: 5
SUM_TIMER_READ_WRITE: 88541938474670000
MIN_TIMER_READ_WRITE: 33093499108000
AVG_TIMER_READ_WRITE: 17708387694934000
MAX_TIMER_READ_WRITE: 44223119349124000
COUNT_READ_ONLY: 0
SUM_TIMER_READ_ONLY: 0
MIN_TIMER_READ_ONLY: 0
AVG_TIMER_READ_ONLY: 0
MAX_TIMER_READ_ONLY: 0
2 rows in set (0.00 sec)