系统表介绍
socket_summary_by_instance
| 列名 | 含义 |
|---|---|
| EVENT_NAME | 事件名称 |
| OBJECT_INSTANCE_BEGIN | 内存地址 |
| COUNT_STAR | 事件发生次数 |
| SUM_TIMER_WAIT | 事件总等待时间 |
| MIN_TIMER_WAIT | 事件最小等待时间 |
| AVG_TIMER_WAIT | 事件平均等待时间 |
| MAX_TIMER_WAIT | 事件最大等待时间 |
| COUNT_READ | 读操作数量 （RECV, RECVFROM, RECVMSG） |
| SUM_TIMER_READ | 读操作总时间 |
| MIN_TIMER_READ | 读操作最小时间 |
| AVG_TIMER_READ | 读操作平均时间 |
| MAX_TIMER_READ | 读操作最长时间 |
| SUM_NUMBER_OF_BYTES_READ | 总读取字节数 |
| COUNT_WRITE | 总写操作次数（ SEND, SENDTO, SENDMSG） |
| SUM_TIMER_WRITE | 写操作总时间 |
| MIN_TIMER_WRITE | 写操作最小时间 |
| AVG_TIMER_WRITE | 写操作平均时间 |
| MAX_TIMER_WRITE | 写操作最长时间 |
| SUM_NUMBER_OF_BYTES_WRITE | 总写入字节数 |
| COUNT_MISC | 其他操作数量 |
| SUM_TIMER_MISC | 其他操作总时间 |
| MIN_TIMER_MISC | 其他操作最小时间 |
| AVG_TIMER_MISC | 其他操作平均事件 |
| MAX_TIMER_MISC | 其他操作最大时间 |
实例
mysql> select * from socket_summary_by_instance limit 1 \G;
*************************** 1. row ***************************
EVENT_NAME: wait/io/socket/sql/server_tcpip_socket
OBJECT_INSTANCE_BEGIN: 44603392
COUNT_STAR: 20
SUM_TIMER_WAIT: 349962376
MIN_TIMER_WAIT: 10776536
AVG_TIMER_WAIT: 17497912
MAX_TIMER_WAIT: 32011888
COUNT_READ: 0
SUM_TIMER_READ: 0
MIN_TIMER_READ: 0
AVG_TIMER_READ: 0
MAX_TIMER_READ: 0
SUM_NUMBER_OF_BYTES_READ: 0
COUNT_WRITE: 0
SUM_TIMER_WRITE: 0
MIN_TIMER_WRITE: 0
AVG_TIMER_WRITE: 0
MAX_TIMER_WRITE: 0
SUM_NUMBER_OF_BYTES_WRITE: 0
COUNT_MISC: 20
SUM_TIMER_MISC: 349962376
MIN_TIMER_MISC: 10776536
AVG_TIMER_MISC: 17497912
MAX_TIMER_MISC: 32011888
1 row in set (0.00 sec)