SHOW DRAINER STATUS

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

SHOW DRAINER STATUS - 图1

Note

This feature is only applicable to TiDB Self-Hosted and not available on TiDB Cloud.

Examples

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

MySQL compatibility

This statement is a TiDB extension to MySQL syntax.

See also