SingleStore DB

SHOW REBALANCE STATUS

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
  • db_name - name of a SingleStore DB database.

  • This command must be run on the master aggregator node (see Node Requirements for SingleStore DB Commands ).

  • SELECT * FROM information_schema.MV_REBALANCE_STATUS
    WHERE database_name = 'db_name';
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.