Outdated Version
You are viewing an older version of this section. View current production version.
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
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 ).
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.
