Skip to content

Latest commit

 

History

History
37 lines (27 loc) · 1.2 KB

sql-statement-show-drainer-status.md

File metadata and controls

37 lines (27 loc) · 1.2 KB
title summary
SHOW DRAINER STATUS
An overview of the usage of SHOW DRAINER STATUS for the TiDB database.

SHOW DRAINER STATUS

The SHOW DRAINER STATUS statement displays the status information for all Drainer nodes in the cluster.

Examples

{{< copyable "sql" >}}

SHOW DRAINER STATUS;
+----------|----------------|--------|--------------------|---------------------|
|  NodeID  |     Address    | State  |   Max_Commit_Ts    |    Update_Time      |
+----------|----------------|--------|--------------------|---------------------|
| drainer1 | 127.0.0.3:8249 | Online | 408553768673342532 | 2019-05-01 00:00:03 |
+----------|----------------|--------|--------------------|---------------------|
| drainer2 | 127.0.0.4:8249 | Online | 408553768673345531 | 2019-05-01 00:00:04 |
+----------|----------------|--------|--------------------|---------------------|
2 rows in set (0.00 sec)

MySQL compatibility

This statement is a TiDB extension to MySQL syntax.

See also