系统表介绍
events_transactions_summary_by_host_by_event_name 反映了事务级事件按客户端IP与事件分组
列名 | 含义 |
---|---|
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_host_by_event_name where COUNT_STAR > 0 \G;
*************************** 1. row ***************************
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 ***************************
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)