Outdated Version
You are viewing an older version of this section. View current production version.
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
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)