SingleStore DB

SHOW REBALANCE ALL DATABASES STATUS

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.