Skip to content

Latest commit

 

History

History
51 lines (36 loc) · 2.12 KB

sql-statement-show-distribution-jobs.md

File metadata and controls

51 lines (36 loc) · 2.12 KB
title summary
SHOW DISTRIBUTION JOBS
An overview of the usage of SHOW DISTRIBUTION JOBS for the TiDB database.

SHOW DISTRIBUTION JOBS New in v8.5.4 and v9.0.0

The SHOW DISTRIBUTION JOBS statement shows all current Region distribution jobs.

Note:

This feature is not available on {{{ .starter }}} and {{{ .essential }}} clusters.

Syntax

ShowDistributionJobsStmt ::=
    "SHOW" "DISTRIBUTION" "JOBS"

Examples

Show all current Region distribution jobs:

SHOW DISTRIBUTION JOBS;
+--------+----------+-------+----------------+--------+----------------+-----------+---------------------+---------------------+---------------------+
| Job_ID | Database | Table | Partition_List | Engine | Rule           | Status    | Create_Time         | Start_Time          | Finish_Time         |
+--------+----------+-------+----------------+--------+----------------+-----------+---------------------+---------------------+---------------------+
|    100 | test     | t1    | NULL           | tikv   | leader-scatter | finished  | 2025-04-24 16:09:55 | 2025-04-24 16:09:55 | 2025-04-24 17:09:59 |
|    101 | test     | t2    | NULL           | tikv   | learner-scatter| cancelled | 2025-05-08 15:33:29 | 2025-05-08 15:33:29 | 2025-05-08 15:33:37 |
|    102 | test     | t5    | p1,p2          | tikv   | peer-scatter   | cancelled | 2025-05-21 15:32:44 | 2025-05-21 15:32:47 | 2025-05-21 15:32:47 |
+--------+----------+-------+----------------+--------+----------------+-----------+---------------------+---------------------+---------------------+

MySQL compatibility

This statement is a TiDB extension to MySQL syntax.

See also