CANCEL TRAFFIC JOBS
TiDB v9.0.0 引入了 CANCEL TRAFFIC JOBS 语法，用于取消集群中所有 TiProxy 正在执行的流量捕获或回放任务。该操作需要如下权限：
- 取消流量捕获任务，需要有
SUPER或TRAFFIC_CAPTURE_ADMIN权限。 - 取消流量回放任务，需要有
SUPER或TRAFFIC_REPLAY_ADMIN权限。
语法图
- TrafficStmt
TrafficStmt ::=
"CANCEL" "TRAFFIC" "JOBS"
示例
假设当前有 2 台 TiProxy 正在进行流量捕获：
SHOW TRAFFIC JOBS;
+----------------------------+----------+----------------+---------+----------+---------+-------------+----------------------------------------------------------------------------+
| START_TIME | END_TIME | INSTANCE | TYPE | PROGRESS | STATUS | FAIL_REASON | PARAMS |
+----------------------------+----------+----------------+---------+----------+---------+-------------+----------------------------------------------------------------------------+
| 2024-12-17 10:54:41.000000 | | 10.1.0.10:3080 | capture | 45% | running | | OUTPUT="/tmp/traffic", DURATION="90m", COMPRESS=true, ENCRYPTION_METHOD="" |
| 2024-12-17 10:54:41.000000 | | 10.1.0.11:3080 | capture | 45% | running | | OUTPUT="/tmp/traffic", DURATION="90m", COMPRESS=true, ENCRYPTION_METHOD="" |
+----------------------------+----------+----------------+---------+----------+---------+-------------+----------------------------------------------------------------------------+
2 rows in set (0.01 sec)
取消当前的任务：
CANCEL TRAFFIC JOBS;
Query OK, 0 rows affected (0.13 sec)
再次查看任务，显示任务已被取消：
SHOW TRAFFIC JOBS;
+----------------------------+----------------------------+----------------+---------+----------+----------+------------------+----------------------------------------------------------------------------+
| START_TIME | END_TIME | INSTANCE | TYPE | PROGRESS | STATUS | FAIL_REASON | PARAMS |
+----------------------------+----------------------------+----------------+---------+----------+----------+------------------+----------------------------------------------------------------------------+
| 2024-12-17 10:54:41.000000 | 2024-12-17 11:34:42.000000 | 10.1.0.10:3080 | capture | 45% | canceled | manually stopped | OUTPUT="/tmp/traffic", DURATION="90m", COMPRESS=true, ENCRYPTION_METHOD="" |
| 2024-12-17 10:54:41.000000 | 2024-12-17 11:34:42.000000 | 10.1.0.11:3080 | capture | 45% | canceled | manually stopped | OUTPUT="/tmp/traffic", DURATION="90m", COMPRESS=true, ENCRYPTION_METHOD="" |
+----------------------------+----------------------------+----------------+---------+----------+----------+------------------+----------------------------------------------------------------------------+
2 rows in set (0.01 sec)
MySQL 兼容性
该语句是 TiDB 对 MySQL 语法的扩展。