SHOW REBALANCE ALL DATABASES STATUS
On this page
Shows the status of the currently executing REBALANCE ALL DATABASES operation.
Syntax
SHOW REBALANCE ALL DATABASES STATUS;
Example
Run the following command to rebalance partitions on all databases in the cluster:
REBALANCE ALL DATABASES;
View the status of REBALANCE ALL DATABASES while it is still running:
SHOW REBALANCE ALL DATABASES STATUS;+----------+-----------------------------------+---------+-------------+-------------+-------+-----------+--------------+
| Database | Action | Ordinal | Target_Host | Target_Port | Phase | Status | Running_Time |
+----------+-----------------------------------+---------+-------------+-------------+-------+-----------+--------------+
| x_db | COPY PARTITION | 13 | 127.0.0.1 | 10002 | 3 | success | 4009 |
| x_db | COPY PARTITION | 2 | 127.0.0.1 | 10003 | 4 | success | 5109 |
| x_db | COPY PARTITION | 2 | 127.0.0.1 | 10004 | 4 | success | 5112 |
| x_db | PROMOTE PARTITION WITH DROP FORCE | 2 | 127.0.0.1 | 10003 | 5 | running | 405 |
| x_db | DROP PARTITION | 2 | 127.0.0.1 | 10002 | 6 | scheduled | NULL |
| x_db | DROP PARTITION | 13 | 127.0.0.1 | 10004 | 6 | scheduled | NULL |
+----------+-----------------------------------+---------+-------------+-------------+-------+-----------+--------------+Note: The Status column displays success for the activities that are already complete.
Last modified: September 12, 2022