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

Syntax

EXPLAIN REBALANCE PARTITIONS ON db_name

Remarks

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

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)

Was this Article Helpful?

Thanks For Your Feedback!