系统表介绍
events_transactions_summary_by_account_by_event_name 反映了事务级事件按访客与事务名按访客与事件名
| 列名 | 含义 |
|---|---|
| USER | 用户名 |
| HOST | 主机名 |
| 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_account_by_event_name where COUNT_STAR >> 0 \G;
*************************** 1. row ***************************
USER: root
HOST: localhost
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
HOST: 192.168.2.1
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.01 sec)