table__summary_表 - xiaoboluo768/mysql-system-schema GitHub Wiki

包含如下几张表，performance_schema在这些表中按照不同的分组列（不同纬度）进行聚合表IO等待和锁等待事件相关的数据（例如：执行次数，总等待时间，最小、最大、平均等待时间），注意，表IO等待和锁等待事件instruments（wait/io/table/sql/handler）默认开启，在consumers表中无具体的对应配置，默认表IO等待和锁等待事件摘要表中就会聚合相关事件信息

admin@localhost : performance_schema 06:50:03> show tables like '%table%summary%';
+------------------------------------------------+
| Tables_in_performance_schema (%table%summary%) |
+------------------------------------------------+
| table_io_waits_summary_by_index_usage          |
| table_io_waits_summary_by_table                |
| table_lock_waits_summary_by_table              |
+------------------------------------------------+
3 rows in set (0.00 sec)

表I/O等待和锁等待事件摘要表：
- table_io_waits_summary_by_index_usage：按照每个索引分组统计的表I/O等待事件信息
- table_io_waits_summary_by_table：按照每个表分组统计的表I/O等待事件信息
- table_lock_waits_summary_by_table：按照每个表分组统计的锁等待事件信息
其中，都有table_io_waits_summary_by_table 表的字段，除持之外，table_io_waits_summary_by_index_usage表多了INDEX_NAME字段，table_lock_waits_summary_by_table表的字段详见后续部分

CREATE TABLE `table_io_waits_summary_by_table` (
  `OBJECT_TYPE` varchar(64) DEFAULT NULL,
  `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
  `OBJECT_NAME` varchar(64) DEFAULT NULL,
  `COUNT_STAR` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
  `COUNT_READ` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_READ` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_READ` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_READ` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_READ` bigint(20) unsigned NOT NULL,
  `COUNT_WRITE` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL,
  `COUNT_FETCH` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_FETCH` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_FETCH` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_FETCH` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_FETCH` bigint(20) unsigned NOT NULL,
  `COUNT_INSERT` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_INSERT` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_INSERT` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_INSERT` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_INSERT` bigint(20) unsigned NOT NULL,
  `COUNT_UPDATE` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_UPDATE` bigint(20) unsigned NOT NULL,
  `COUNT_DELETE` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_DELETE` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_DELETE` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_DELETE` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_DELETE` bigint(20) unsigned NOT NULL
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8

table_lock_waits_summary_by_table表字段

CREATE TABLE `table_lock_waits_summary_by_table` (
  `OBJECT_TYPE` varchar(64) DEFAULT NULL,
  `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
  `OBJECT_NAME` varchar(64) DEFAULT NULL,
  `COUNT_STAR` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_WAIT` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_WAIT` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_WAIT` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_WAIT` bigint(20) unsigned NOT NULL,
  `COUNT_READ` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_READ` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_READ` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_READ` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_READ` bigint(20) unsigned NOT NULL,
  `COUNT_WRITE` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_WRITE` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_WRITE` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_WRITE` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_WRITE` bigint(20) unsigned NOT NULL,
  `COUNT_READ_NORMAL` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_READ_NORMAL` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_READ_NORMAL` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_READ_NORMAL` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_READ_NORMAL` bigint(20) unsigned NOT NULL,
  `COUNT_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_READ_WITH_SHARED_LOCKS` bigint(20) unsigned NOT NULL,
  `COUNT_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_READ_HIGH_PRIORITY` bigint(20) unsigned NOT NULL,
  `COUNT_READ_NO_INSERT` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_READ_NO_INSERT` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_READ_NO_INSERT` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_READ_NO_INSERT` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_READ_NO_INSERT` bigint(20) unsigned NOT NULL,
  `COUNT_READ_EXTERNAL` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_READ_EXTERNAL` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_READ_EXTERNAL` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_READ_EXTERNAL` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_READ_EXTERNAL` bigint(20) unsigned NOT NULL,
  `COUNT_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_WRITE_ALLOW_WRITE` bigint(20) unsigned NOT NULL,
  `COUNT_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_WRITE_CONCURRENT_INSERT` bigint(20) unsigned NOT NULL,
  `COUNT_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_WRITE_LOW_PRIORITY` bigint(20) unsigned NOT NULL,
  `COUNT_WRITE_NORMAL` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_WRITE_NORMAL` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_WRITE_NORMAL` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_WRITE_NORMAL` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_WRITE_NORMAL` bigint(20) unsigned NOT NULL,
  `COUNT_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL,
  `SUM_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL,
  `MIN_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL,
  `AVG_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL,
  `MAX_TIMER_WRITE_EXTERNAL` bigint(20) unsigned NOT NULL
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8

table_io_waits_summary_by_table表：
- 按照OBJECT_TYPE、OBJECT_SCHEMA、OBJECT_NAME列进行分组。这些列与events_waits_current表中同名字段的含义相同
- 按照如下列进行聚合。例如：聚合插入，更新和删除操作相关的耗时，执行次数等
  - COUNT_STAR，SUM_TIMER_WAIT，MIN_TIMER_WAIT，AVG_TIMER_WAIT，MAX_TIMER_WAIT：这些列聚合所有I/O操作。聚合值与相应的xxx_READ和xxx_WRITE聚合列值之和相等（例如：SUM_TIMER_WAIT=SUM_TIMER_READ+SUM_TIMER_WRITE+SUM_TIMER_FETCH+SUM_TIMER_INSERT+SUM_TIMER_UPDATE+SUM_TIMER_DELETE）
  - COUNT_READ，SUM_TIMER_READ，MIN_TIMER_READ，AVG_TIMER_READ，MAX_TIMER_READ：这些列聚合所有读取操作。聚合值与相应的xxx_FETCH聚合列值之和相等
  - COUNT_WRITE，SUM_TIMER_WRITE，MIN_TIMER_WRITE，AVG_TIMER_WRITE，MAX_TIMER_WRITE：这些列聚合所有写入操作。聚合值与相应的xxx_INSERT，xxx_UPDATE和xxx_DELETE聚合列之和相等
  - COUNT_FETCH，SUM_TIMER_FETCH，MIN_TIMER_FETCH，AVG_TIMER_FETCH，MAX_TIMER_FETCH：这些列聚合所有的fetch操作
  - COUNT_INSERT，SUM_TIMER_INSERT，MIN_TIMER_INSERT，AVG_TIMER_INSERT，MAX_TIMER_INSERT：这些列聚合所有插入操作
  - COUNT_UPDATE，SUM_TIMER_UPDATE，MIN_TIMER_UPDATE，AVG_TIMER_UPDATE，MAX_TIMER_UPDATE：这些列聚合所有更新操作
  - COUNT_DELETE，SUM_TIMER_DELETE，MIN_TIMER_DELETE，AVG_TIMER_DELETE，MAX_TIMER_DELETE：这些列聚合所有删除操作
- 该表允许使用TRUNCATE TABLE语句。只将聚合列重置为零，而不是删除行。对该表执行truncate还会隐式truncate table_io_waits_summary_by_index_usage表
table_io_waits_summary_by_index_usage表： *按照与table_io_waits_summary_by_table的分组列+INDEX_NAME列进行分组，INDEX_NAME有如下几种：
- 如果使用到了索引，则这里显示索引的名字，如果为PRIMARY，则表示表I/O使用到了主键索引
- 如果值为NULL，则表示表I/O没有使用到索引
- 如果是插入操作，则无法使用到索引，此时的聚合值是按照INDEX_NAME = NULL计算的
- 该表允许使用TRUNCATE TABLE语句。只将聚合列重置为零，而不是删除行。该表执行truncate时也会隐式触发table_io_waits_summary_by_table表的truncate操作。另外使用DDL语句更改索引结构时，会导致该表的所有索引统计信息被重置
table_lock_waits_summary_by_table表：
- 该表的分组列与table_io_waits_summary_by_table表相同
- 该表包含有关内部和外部锁的信息：
  - 内部锁对应SQL层中的锁。是通过调用thr_lock（）函数来实现的。（官方手册上说有一个OPERATION列来区分锁类型，该列有效值为：read normal、read with shared locks、read high priority、read no insert、write allow write、write concurrent insert、write delayed、write low priority、write normal。但在该表的定义上并没有看到该字段)
  - 外部锁对应存储引擎层中的锁。通过调用handler::external_lock（）函数来实现。（官方手册上说有一个OPERATION列来区分锁类型，该列有效值为：read external、write external。但在该表的定义上并没有看到该字段)
- table_lock_waits_summary_by_table表按照OBJECT_TYPE、OBJECT_SCHEMA、OBJECT_NAME列进行分组。这些列与events_waits_current表中同名字段的含义相同
- table_lock_waits_summary_by_table表按照如下聚合列进行聚合：
  - COUNT_STAR，SUM_TIMER_WAIT，MIN_TIMER_WAIT，AVG_TIMER_WAIT，MAX_TIMER_WAIT：这些列聚合所有锁操作数量和时间。这些聚合值与相应的xxx_READ和xxx_WRITE聚合列值相等
  - COUNT_READ，SUM_TIMER_READ，MIN_TIMER_READ，AVG_TIMER_READ，MAX_TIMER_READ：这些列聚合所有读锁操作数量和时间。这些聚合值与相应的xxx_READ_NORMAL，xxx_READ_WITH_SHARED_LOCKS，xxx_READ_HIGH_PRIORITY和xxx_READ_NO_INSERT聚合列值相等
  - COUNT_WRITE，SUM_TIMER_WRITE，MIN_TIMER_WRITE，AVG_TIMER_WRITE，MAX_TIMER_WRITE：这些列聚合了所有写锁操作数量和时间。这些聚合值与相应的xxx_WRITE_ALLOW_WRITE，xxx_WRITE_CONCURRENT_INSERT，xxx_WRITE_LOW_PRIORITY和xxx_WRITE_NORMAL聚合列值相等
  - 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：这些列聚合了外部写锁数量和时间
- 该表允许使用TRUNCATE TABLE语句。只将聚合列重置为零，而不是删除行
表记录内容示例

# table_io_waits_summary_by_index_usage表
admin@localhost : performance_schema 01:55:49> select * from table_io_waits_summary_by_index_usage where SUM_TIMER_WAIT!=0\G;
*************************** 1. row ***************************
    OBJECT_TYPE: TABLE
  OBJECT_SCHEMA: xiaoboluo
    OBJECT_NAME: test
      INDEX_NAME: PRIMARY
      COUNT_STAR: 1
  SUM_TIMER_WAIT: 56688392
  MIN_TIMER_WAIT: 56688392
  AVG_TIMER_WAIT: 56688392
  MAX_TIMER_WAIT: 56688392
      COUNT_READ: 1
  SUM_TIMER_READ: 56688392
  MIN_TIMER_READ: 56688392
  AVG_TIMER_READ: 56688392
  MAX_TIMER_READ: 56688392
    COUNT_WRITE: 0
SUM_TIMER_WRITE: 0
MIN_TIMER_WRITE: 0
AVG_TIMER_WRITE: 0
MAX_TIMER_WRITE: 0
    COUNT_FETCH: 1
SUM_TIMER_FETCH: 56688392
MIN_TIMER_FETCH: 56688392
AVG_TIMER_FETCH: 56688392
MAX_TIMER_FETCH: 56688392
    COUNT_INSERT: 0
SUM_TIMER_INSERT: 0
MIN_TIMER_INSERT: 0
AVG_TIMER_INSERT: 0
MAX_TIMER_INSERT: 0
    COUNT_UPDATE: 0
SUM_TIMER_UPDATE: 0
MIN_TIMER_UPDATE: 0
AVG_TIMER_UPDATE: 0
MAX_TIMER_UPDATE: 0
    COUNT_DELETE: 0
SUM_TIMER_DELETE: 0
MIN_TIMER_DELETE: 0
AVG_TIMER_DELETE: 0
MAX_TIMER_DELETE: 0
1 row in set (0.00 sec)

# table_io_waits_summary_by_table表
admin@localhost : performance_schema 01:56:16> select * from table_io_waits_summary_by_table where SUM_TIMER_WAIT!=0\G;
*************************** 1. row ***************************
    OBJECT_TYPE: TABLE
  OBJECT_SCHEMA: xiaoboluo
    OBJECT_NAME: test
      COUNT_STAR: 1
  SUM_TIMER_WAIT: 56688392
  MIN_TIMER_WAIT: 56688392
  AVG_TIMER_WAIT: 56688392
  MAX_TIMER_WAIT: 56688392
      COUNT_READ: 1
  SUM_TIMER_READ: 56688392
  MIN_TIMER_READ: 56688392
  AVG_TIMER_READ: 56688392
  MAX_TIMER_READ: 56688392
    COUNT_WRITE: 0
SUM_TIMER_WRITE: 0
MIN_TIMER_WRITE: 0
AVG_TIMER_WRITE: 0
MAX_TIMER_WRITE: 0
    COUNT_FETCH: 1
SUM_TIMER_FETCH: 56688392
MIN_TIMER_FETCH: 56688392
AVG_TIMER_FETCH: 56688392
MAX_TIMER_FETCH: 56688392
    COUNT_INSERT: 0
SUM_TIMER_INSERT: 0
MIN_TIMER_INSERT: 0
AVG_TIMER_INSERT: 0
MAX_TIMER_INSERT: 0
    COUNT_UPDATE: 0
SUM_TIMER_UPDATE: 0
MIN_TIMER_UPDATE: 0
AVG_TIMER_UPDATE: 0
MAX_TIMER_UPDATE: 0
    COUNT_DELETE: 0
SUM_TIMER_DELETE: 0
MIN_TIMER_DELETE: 0
AVG_TIMER_DELETE: 0
MAX_TIMER_DELETE: 0
1 row in set (0.00 sec)

# table_lock_waits_summary_by_table表
admin@localhost : performance_schema 01:57:20> select * from table_lock_waits_summary_by_table where SUM_TIMER_WAIT!=0\G;
*************************** 1. row ***************************
                      OBJECT_TYPE: TABLE
                    OBJECT_SCHEMA: xiaoboluo
                      OBJECT_NAME: test
                      COUNT_STAR: 1
                  SUM_TIMER_WAIT: 2847824
                  MIN_TIMER_WAIT: 2847824
                  AVG_TIMER_WAIT: 2847824
                  MAX_TIMER_WAIT: 2847824
                      COUNT_READ: 1
                  SUM_TIMER_READ: 2847824
                  MIN_TIMER_READ: 2847824
                  AVG_TIMER_READ: 2847824
                  MAX_TIMER_READ: 2847824
                      COUNT_WRITE: 0
                  SUM_TIMER_WRITE: 0
                  MIN_TIMER_WRITE: 0
                  AVG_TIMER_WRITE: 0
                  MAX_TIMER_WRITE: 0
                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: 1
          SUM_TIMER_READ_EXTERNAL: 2847824
          MIN_TIMER_READ_EXTERNAL: 2847824
          AVG_TIMER_READ_EXTERNAL: 2847824
          MAX_TIMER_READ_EXTERNAL: 2847824
          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: 0
        SUM_TIMER_WRITE_EXTERNAL: 0
        MIN_TIMER_WRITE_EXTERNAL: 0
        AVG_TIMER_WRITE_EXTERNAL: 0
        MAX_TIMER_WRITE_EXTERNAL: 0
1 row in set (0.00 sec)

参考链接：https://dev.mysql.com/doc/refman/5.7/en/table-waits-summary-tables.html

上一篇： file_summary_*表 | 下一篇： socket_summary_*表

table_*_summary_*表 - xiaoboluo768/mysql-system-schema GitHub Wiki

table__summary_表 - xiaoboluo768/mysql-system-schema GitHub Wiki