SHOW REBALANCE STATUS

Syntax

SQL

SHOW REBALANCE STATUS ON db_name

Remarks

db_name - name of a SingleStore database.
This command must be run on the master aggregator node (see Node Requirements for SingleStore Commands ).

SQL

SELECT * FROM information_schema.MV_REBALANCE_STATUS
WHERE database_name = 'db_name';

Refer to the Permission Matrix for the required permissions.

Example

Run the following command to rebalance partitions:

SQL

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.