SingleStore DB

SHOW REBALANCE ALL DATABASES STATUS

Shows the status of the currently executing REBALANCE ALL DATABASES operation.

Syntax
SHOW REBALANCE ALL DATABASES STATUS;
Remarks

Alternatively, you can query the information schema view MV_REBALANCE_STATUS , which returns the same output as the SHOW REBALANCE ALL DATABASES STATUS command.

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 | Estimated_Time_Remaining_Ms |
+----------+-----------------------------------+---------+-------------+-------------+-------+-----------+--------------+-----------------------------+
| x_db     | COPY PARTITION                    | 13      | 127.0.0.1   | 10002       | 3     | success   | 4009         | 0                           |
| x_db     | COPY PARTITION                    | 2       | 127.0.0.1   | 10003       | 4     | success   | 5109         | 0                           |
| x_db     | COPY PARTITION                    | 2       | 127.0.0.1   | 10004       | 4     | success   | 5112         | 0                           |
| x_db     | PROMOTE PARTITION WITH DROP FORCE | 2       | 127.0.0.1   | 10003       | 5     | running   | 405          | 1130                        |
| x_db     | DROP PARTITION                    | 2       | 127.0.0.1   | 10002       | 6     | scheduled | NULL         | 1002                        |
| x_db     | DROP PARTITION                    | 13      | 127.0.0.1   | 10004       | 6     | scheduled | NULL         | 1002                        |
+----------+-----------------------------------+---------+-------------+-------------+-------+-----------+--------------+-----------------------------+

Note: The Status displays success for the activities that are already complete. The Estimated_Time_Remaining_Ms displays the estimated remaining time (in milliseconds) for each low-level command to complete.