SingleStore DB

EXPLAIN REBALANCE PARTITIONS

Returns the set of steps that REBALANCE PARTITIONS would run if you executed it now.

Syntax
EXPLAIN REBALANCE PARTITIONS ON db_name
Remarks
Example
EXPLAIN REBALANCE PARTITIONS ON memsql_demo;
+-----------------------------+---------+-------------+-------------+-------+
| Action                      | Ordinal | Target_Host | Target_Port | Phase | 
+-----------------------------+---------+-------------+-------------+-------+
| COPY PARTITION              | 13      | 127.0.0.1   | 10002       | 3     |
| COPY PARTITION              | 2       | 127.0.0.1   | 10003       | 4     |
| COPY PARTITION              | 2       | 127.0.0.1   | 10004       | 4     |
| PROMOTE PARTITION WITH DROP | 2       | 127.0.0.1   | 10003       | 5     | 
| DROP PARTITION              | 2       | 127.0.0.1   | 10002       | 6     | 
| DROP PARTITION              | 13      | 127.0.0.1   | 10004       | 6     | 
+-----------------------------+---------+-------------+-------------+-------+