You are viewing an older version of this section. View current production version.

SHOW REBALANCE STATUS

Info

MemSQL Helios 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.