Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

SHOW REBALANCE STATUS

Info

SingleStore Managed Service does not support this command.

Shows the status of the currently executing REBALANCE PARTITIONS, RESTORE REDUNDANCY, RESTORE, ATTACH LEAF, auto-failover or auto-attach operation on a database.

Syntax

SHOW REBALANCE STATUS ON db_name

Remarks

Example

Run the following command to rebalance partitions:

REBALANCE PARTITIONS ON mydb;

View the status of REBALANCE PARTITIONS while it is still running:

SHOW REBALANCE STATUS ON mydb;
****
+-----------------------------------+---------+-------------+-------------+-------+-----------+--------------+
| Action                            | Ordinal | Target_Host | Target_Port | Phase | Status    | Running_Time |
+-----------------------------------+---------+-------------+-------------+-------+-----------+--------------+
| COPY PARTITION                    | 13      | 127.0.0.1   | 10002       | 3     | success   | 4009         |
| COPY PARTITION                    | 2       | 127.0.0.1   | 10003       | 4     | success   | 5109         |
| COPY PARTITION                    | 2       | 127.0.0.1   | 10004       | 4     | success   | 5112         |
| PROMOTE PARTITION WITH DROP FORCE | 2       | 127.0.0.1   | 10003       | 5     | running   | 405          |
| DROP PARTITION                    | 2       | 127.0.0.1   | 10002       | 6     | scheduled | NULL         |
| DROP PARTITION                    | 13      | 127.0.0.1   | 10004       | 6     | scheduled | NULL         |
+-----------------------------------+---------+-------------+-------------+-------+-----------+--------------+

Note:: The STATUS column displays success for the activities that are already complete.