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 MemSQL database.
• This command must be run on the master aggregator node (see Node Requirements for MemSQL 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.

Was this Article Helpful?

Thanks For Your Feedback!