RUNAWAY_WATCHES

RUNAWAY_WATCHES 表展示资源消耗超出预期的查询 Runaway Queries 监控列表,见 Runaway Queries

USE INFORMATION_SCHEMA; DESC RUNAWAY_WATCHES;
+---------------------+--------------+------+------+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------------+--------------+------+------+---------+-------+ | ID | bigint(64) | NO | | NULL | | | RESOURCE_GROUP_NAME | varchar(32) | NO | | NULL | | | START_TIME | varchar(32) | NO | | NULL | | | END_TIME | varchar(32) | YES | | NULL | | | WATCH | varchar(12) | NO | | NULL | | | WATCH_TEXT | text | NO | | NULL | | | SOURCE | varchar(128) | NO | | NULL | | | ACTION | varchar(12) | NO | | NULL | | +---------------------+--------------+------+------+---------+-------+ 8 rows in set (0.00 sec)

示例

查询 Runaway Queries 识别名单:

SELECT * FROM INFORMATION_SCHEMA.RUNAWAY_WATCHES\G;

输出结果如下:

*************************** 1. row *************************** ID: 20003 RESOURCE_GROUP_NAME: rg2 START_TIME: 2023-07-28 13:06:08 END_TIME: UNLIMITED WATCH: Similar WATCH_TEXT: 5b7fd445c5756a16f910192ad449c02348656a5e9d2aa61615e6049afbc4a82e SOURCE: 127.0.0.1:4000 ACTION: Kill *************************** 2. row *************************** ID: 16004 RESOURCE_GROUP_NAME: rg2 START_TIME: 2023-07-28 01:45:30 END_TIME: UNLIMITED WATCH: Similar WATCH_TEXT: 3d48fca401d8cbb31a9f29adc9c0f9d4be967ca80a34f59c15f73af94e000c84 SOURCE: 127.0.0.1:4000 ACTION: Kill 2 rows in set (0.00 sec)

添加一个识别项到资源组 rg1

QUERY WATCH ADD RESOURCE GROUP rg1 SQL TEXT EXACT TO 'select * from sbtest.sbtest1';

再次查询 Runaway Queries 识别名单:

SELECT * FROM INFORMATION_SCHEMA.RUNAWAY_WATCHES\G;

输出结果如下:

*************************** 1. row *************************** ID: 20003 RESOURCE_GROUP_NAME: rg2 START_TIME: 2023-07-28 13:06:08 END_TIME: UNLIMITED WATCH: Similar WATCH_TEXT: 5b7fd445c5756a16f910192ad449c02348656a5e9d2aa61615e6049afbc4a82e SOURCE: 127.0.0.1:4000 ACTION: Kill *************************** 2. row *************************** ID: 16004 RESOURCE_GROUP_NAME: rg2 START_TIME: 2023-07-28 01:45:30 END_TIME: UNLIMITED WATCH: Similar WATCH_TEXT: 3d48fca401d8cbb31a9f29adc9c0f9d4be967ca80a34f59c15f73af94e000c84 SOURCE: 127.0.0.1:4000 ACTION: Kill *************************** 3. row *************************** ID: 20004 RESOURCE_GROUP_NAME: rg1 START_TIME: 2023-07-28 14:23:04 END_TIME: UNLIMITED WATCH: Exact WATCH_TEXT: select * from sbtest.sbtest1 SOURCE: manual ACTION: NoneAction 3 row in set (0.00 sec)

RUNAWAY_WATCHES 表中列的含义如下:

  • ID:识别项 ID。
  • RESOURCE_GROUP_NAME:资源组名称。
  • START_TIME:开始时间。
  • END_TIME:结束时间。UNLIMITED 表示识别项的有效时间无限长。
  • WATCH:识别匹配类型,其值如下:
    • Plan 表示按照 Plan Digest 匹配,此时列 WATCH_TEXT 显示 Plan Digest。
    • Similar 表示按照 SQL Digest 匹配,此时列 WATCH_TEXT 显示 SQL Digest。
    • Exact 表示按照 SQL 文本匹配,此时列 WATCH_TEXT 显示 SQL 文本。
  • SOURCE:识别项来源,如果是被 QUERY_LIMIT 规则识别,则显示识别到的 TiDB IP;如果是手动添加,则显示 manual
  • ACTION:识别后的对应操作。