You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

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

memsql> 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)