Outdated Version

You are viewing an older version of this section. View current production version.

EXPLAIN REBALANCE PARTITIONS

Info

MemSQL Helios 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

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)