SHOW TRAFFIC JOBS
TiDB v9.0.0 引入了 SHOW TRAFFIC JOBS 语法，用于查看集群中所有 TiProxy 的流量捕获或回放任务。输出结果中，每行代表一台 TiProxy 实例的一个任务。每台 TiProxy 实例最多保存最近的 10 个任务。
执行该语句的结果取决于当前用户的权限：
- 具有
TRAFFIC_CAPTURE_ADMIN权限的用户可查看流量捕获任务。 - 具有
TRAFFIC_REPLAY_ADMIN权限的用户可查看流量回放任务。 - 具有
SUPER权限或同时拥有上述两种权限的用户可同时查看流量捕获和流量回放任务。
SHOW TRAFFIC JOBS 返回以下列：
语法图
- TrafficStmt
TrafficStmt ::=
"SHOW" "TRAFFIC" "JOBS"
示例
查看流量捕获或回放任务：
SHOW TRAFFIC JOBS;
下面输出示例表示有 2 台 TiProxy 正在捕获流量，进度都为 45%：
+----------------------------+----------+----------------+---------+----------+---------+-------------+----------------------------------------------------------------------------+
| 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)
下面输出示例表示 2 台 TiProxy 的流量回放任务被手动取消：
+----------------------------+----------------------------+----------------+--------+----------+----------+------------------+--------------------------------------------------------------------+
| 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 | replay | 70% | canceled | manually stopped | INPUT="/tmp/traffic", USER="root", SPEED=0.000000, READ_ONLY=false |
| 2024-12-17 10:54:41.000000 | 2024-12-17 11:34:43.000000 | 10.1.0.11:3080 | replay | 69% | canceled | manually stopped | INPUT="/tmp/traffic", USER="root", SPEED=0.000000, READ_ONLY=false |
+----------------------------+----------------------------+----------------+--------+----------+----------+------------------+--------------------------------------------------------------------+
2 rows in set (0.01 sec)
MySQL 兼容性
该语句是 TiDB 对 MySQL 语法的扩展。