Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

EXPLAIN REBALANCE PARTITIONS

Info

SingleStore Managed Service does not support this command.

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 |
+-------------------+---------+----------------------------+-------------+-------+
| PROMOTE PARTITION |      46 | ip-10-0-2-180.ec2.internal |        3306 |     1 |
| COPY PARTITION    |      46 | ip-10-0-3-62.ec2.internal  |        3306 |     2 |
| COPY PARTITION    |      58 | ip-10-0-3-62.ec2.internal  |        3306 |     2 |
| COPY PARTITION    |      63 | ip-10-0-1-25.ec2.internal  |        3306 |     2 |
| PROMOTE PARTITION |       2 | ip-10-0-3-62.ec2.internal  |        3306 |     6 |
| COPY PARTITION    |       2 | ip-10-0-2-180.ec2.internal |        3306 |     7 |
+-------------------+---------+----------------------------+-------------+-------+
6 rows in set (0.00 sec)