Outdated Version

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

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)