QUERY WATCH
QUERY WATCH 语句用于在资源组中手动管理 Runaway Queries 监控列表。
语法图
- AddQueryWatchStmt
- QueryWatchOptionList
- QueryWatchOption
- ResourceGroupName
- ResourceGroupRunawayActionOption
- QueryWatchTextOption
- ResourceGroupRunawayWatchOption
- DropQueryWatchStmt
AddQueryWatchStmt ::=
"QUERY" "WATCH" "ADD" QueryWatchOptionList
QueryWatchOptionList ::=
QueryWatchOption
| QueryWatchOptionList QueryWatchOption
| QueryWatchOptionList ',' QueryWatchOption
QueryWatchOption ::=
"RESOURCE" "GROUP" ResourceGroupName
| "RESOURCE" "GROUP" UserVariable
| "ACTION" EqOpt ResourceGroupRunawayActionOption
| QueryWatchTextOption
ResourceGroupName ::=
Identifier
| "DEFAULT"
ResourceGroupRunawayActionOption ::=
DRYRUN
| COOLDOWN
| KILL
| "SWITCH_GROUP" '(' ResourceGroupName ')'
QueryWatchTextOption ::=
"SQL" "DIGEST" SimpleExpr
| "PLAN" "DIGEST" SimpleExpr
| "SQL" "TEXT" ResourceGroupRunawayWatchOption "TO" SimpleExpr
ResourceGroupRunawayWatchOption ::=
"EXACT"
| "SIMILAR"
| "PLAN"
DropQueryWatchStmt ::=
"QUERY" "WATCH" "REMOVE" NUM
参数说明
详见 QUERY WATCH 语句说明。
MySQL 兼容性
该语句是 TiDB 对 MySQL 语法的扩展。