系统表介绍
table_lock_waits_summary_by_table 按照表名记录所等待信息
| 列名 | 含义 |
|---|---|
| OBJECT_TYPE | 对象类型 |
| OBJECT_SCHEMA | 对象所属模式 |
| OBJECT_NAME | 表名 |
| COUNT_STAR | 事件汇总数据 |
| SUM_TIMER_WAIT | 事件总等待时间 |
| MIN_TIMER_WAIT | 事件最小等待时间 |
| AVG_TIMER_WAIT | 时间平均等待时间 |
| MAX_TIMER_WAIT | 时间最大等待时间 |
| COUNT_READ | 读操作数量 |
| SUM_TIMER_READ | 读操作总时间 |
| MIN_TIMER_READ | 读操作最小时间 |
| AVG_TIMER_READ | 读操作平均时间 |
| MAX_TIMER_READ | 读操作最长时间 |
| COUNT_WRITE | 写操作数量 |
| SUM_TIMER_WRITE | 写操作总时间 |
| MIN_TIMER_WRITE | 写操作最小时间 |
| AVG_TIMER_WRITE | 写操作平均时间 |
| MAX_TIMER_WRITE | 写操作最长时间 |
| COUNT_READ_NORMAL | 内部读取常规锁总次数 |
| SUM_TIMER_READ_NORMAL | 内部读取常规锁总时间 |
| MIN_TIMER_READ_NORMAL | 内部读取常规锁最小时间 |
| AVG_TIMER_READ_NORMAL | 内部读取常规锁平均时间 |
| MAX_TIMER_READ_NORMAL | 内部读取常规锁最大时间 |
| COUNT_READ_WITH_SHARED_LOCKS | 内部共享锁模式读取的总次数 |
| SUM_TIMER_READ_WITH_SHARED_LOCKS | 内部共享锁模式读取的总时间 |
| MIN_TIMER_READ_WITH_SHARED_LOCKS | 内部共享锁模式读取的最小时间 |
| AVG_TIMER_READ_WITH_SHARED_LOCKS | 内部共享锁模式读取的平均时间 |
| MAX_TIMER_READ_WITH_SHARED_LOCKS | 内部共享锁模式读取的最大时间 |
| COUNT_READ_HIGH_PRIORITY | 内部高优先级读锁总次数 |
| SUM_TIMER_READ_HIGH_PRIORITY | 内部高优先级读锁总时间 |
| MIN_TIMER_READ_HIGH_PRIORITY | 内部高优先级读锁最小时间 |
| AVG_TIMER_READ_HIGH_PRIORITY | 内部高优先级读锁平均时间 |
| MAX_TIMER_READ_HIGH_PRIORITY | 内部高优先级读锁最大时间 |
| COUNT_READ_NO_INSERT | 内部非插入读锁总次数 |
| SUM_TIMER_READ_NO_INSERT | 内部非插入读锁总时间 |
| MIN_TIMER_READ_NO_INSERT | 内部非插入读锁最小时间 |
| AVG_TIMER_READ_NO_INSERT | 内部非插入读锁平均时间 |
| MAX_TIMER_READ_NO_INSERT | 内部非插入读锁最大时间 |
| COUNT_READ_EXTERNAL | 外部锁总次数 |
| SUM_TIMER_READ_EXTERNAL | 外部锁总时间 |
| MIN_TIMER_READ_EXTERNAL | 外部锁最小时间 |
| AVG_TIMER_READ_EXTERNAL | 外部锁平均时间 |
| MAX_TIMER_READ_EXTERNAL | 外部锁最大时间 |
| COUNT_WRITE_ALLOW_WRITE | 内部常规写锁总次数 |
| SUM_TIMER_WRITE_ALLOW_WRITE | 内部常规写锁总时间 |
| MIN_TIMER_WRITE_ALLOW_WRITE | 内部常规写锁最小时间 |
| AVG_TIMER_WRITE_ALLOW_WRITE | 内部常规写锁平均时间 |
| MAX_TIMER_WRITE_ALLOW_WRITE | 内部常规写锁最长时间 |
| COUNT_WRITE_CONCURRENT_INSERT | 内部并发插入写锁总次数 |
| SUM_TIMER_WRITE_CONCURRENT_INSERT | 内部并发插入写锁总时间 |
| MIN_TIMER_WRITE_CONCURRENT_INSERT | 内部并发插入写锁最小时间 |
| AVG_TIMER_WRITE_CONCURRENT_INSERT | 内部并发插入写锁平均时间 |
| MAX_TIMER_WRITE_CONCURRENT_INSERT | 内部并发插入写锁最大时间 |
| COUNT_WRITE_LOW_PRIORITY | 内部低优先级写锁总次数 |
| SUM_TIMER_WRITE_LOW_PRIORITY | 内部低优先级写锁总时间 |
| MIN_TIMER_WRITE_LOW_PRIORITY | 内部低优先级写锁最小时间 |
| AVG_TIMER_WRITE_LOW_PRIORITY | 内部低优先级写锁平均时间 |
| MAX_TIMER_WRITE_LOW_PRIORITY | 内部低优先级写锁最大时间 |
| COUNT_WRITE_NORMAL | 内部常规写锁总次数 |
| SUM_TIMER_WRITE_NORMAL | 内部常规写锁总时间 |
| MIN_TIMER_WRITE_NORMAL | 内部常规写锁最小时间 |
| AVG_TIMER_WRITE_NORMAL | 内部常规写锁平均时间 |
| MAX_TIMER_WRITE_NORMAL | 内部常规写锁最大时间 |
| COUNT_WRITE_EXTERNAL | 外部写锁总次数 |
| SUM_TIMER_WRITE_EXTERNAL | 外部写锁总时间 |
| MIN_TIMER_WRITE_EXTERNAL | 外部写锁最小时间 |
| AVG_TIMER_WRITE_EXTERNAL | 外部写锁平均时间 |
| MAX_TIMER_WRITE_EXTERNAL | 外部写锁最大时间 |
实例
mysql> select * from table_lock_waits_summary_by_table where COUNT_STAR >0 limit 1 \G ;
*************************** 1. row ***************************
OBJECT_TYPE: TABLE
OBJECT_SCHEMA: daozhang
OBJECT_NAME: it_task
COUNT_STAR: 3
SUM_TIMER_WAIT: 38196712
MIN_TIMER_WAIT: 2310520
AVG_TIMER_WAIT: 12732112
MAX_TIMER_WAIT: 33281640
COUNT_READ: 2
SUM_TIMER_READ: 35592160
MIN_TIMER_READ: 2310520
AVG_TIMER_READ: 17796080
MAX_TIMER_READ: 33281640
COUNT_WRITE: 1
SUM_TIMER_WRITE: 2604552
MIN_TIMER_WRITE: 2604552
AVG_TIMER_WRITE: 2604552
MAX_TIMER_WRITE: 2604552
COUNT_READ_NORMAL: 0
SUM_TIMER_READ_NORMAL: 0
MIN_TIMER_READ_NORMAL: 0
AVG_TIMER_READ_NORMAL: 0
MAX_TIMER_READ_NORMAL: 0
COUNT_READ_WITH_SHARED_LOCKS: 0
SUM_TIMER_READ_WITH_SHARED_LOCKS: 0
MIN_TIMER_READ_WITH_SHARED_LOCKS: 0
AVG_TIMER_READ_WITH_SHARED_LOCKS: 0
MAX_TIMER_READ_WITH_SHARED_LOCKS: 0
COUNT_READ_HIGH_PRIORITY: 0
SUM_TIMER_READ_HIGH_PRIORITY: 0
MIN_TIMER_READ_HIGH_PRIORITY: 0
AVG_TIMER_READ_HIGH_PRIORITY: 0
MAX_TIMER_READ_HIGH_PRIORITY: 0
COUNT_READ_NO_INSERT: 0
SUM_TIMER_READ_NO_INSERT: 0
MIN_TIMER_READ_NO_INSERT: 0
AVG_TIMER_READ_NO_INSERT: 0
MAX_TIMER_READ_NO_INSERT: 0
COUNT_READ_EXTERNAL: 2
SUM_TIMER_READ_EXTERNAL: 35592160
MIN_TIMER_READ_EXTERNAL: 2310520
AVG_TIMER_READ_EXTERNAL: 17796080
MAX_TIMER_READ_EXTERNAL: 33281640
COUNT_WRITE_ALLOW_WRITE: 0
SUM_TIMER_WRITE_ALLOW_WRITE: 0
MIN_TIMER_WRITE_ALLOW_WRITE: 0
AVG_TIMER_WRITE_ALLOW_WRITE: 0
MAX_TIMER_WRITE_ALLOW_WRITE: 0
COUNT_WRITE_CONCURRENT_INSERT: 0
SUM_TIMER_WRITE_CONCURRENT_INSERT: 0
MIN_TIMER_WRITE_CONCURRENT_INSERT: 0
AVG_TIMER_WRITE_CONCURRENT_INSERT: 0
MAX_TIMER_WRITE_CONCURRENT_INSERT: 0
COUNT_WRITE_LOW_PRIORITY: 0
SUM_TIMER_WRITE_LOW_PRIORITY: 0
MIN_TIMER_WRITE_LOW_PRIORITY: 0
AVG_TIMER_WRITE_LOW_PRIORITY: 0
MAX_TIMER_WRITE_LOW_PRIORITY: 0
COUNT_WRITE_NORMAL: 0
SUM_TIMER_WRITE_NORMAL: 0
MIN_TIMER_WRITE_NORMAL: 0
AVG_TIMER_WRITE_NORMAL: 0
MAX_TIMER_WRITE_NORMAL: 0
COUNT_WRITE_EXTERNAL: 1
SUM_TIMER_WRITE_EXTERNAL: 2604552
MIN_TIMER_WRITE_EXTERNAL: 2604552
AVG_TIMER_WRITE_EXTERNAL: 2604552
MAX_TIMER_WRITE_EXTERNAL: 2604552
1 row in set (0.00 sec)