EXPLAIN REBALANCE PARTITIONS
On this page
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 of a SingleStore database.name -
See MV_
REBALANCE_ STATUS for the column definitions in the result set.
Example
EXPLAIN REBALANCE PARTITIONS ON memsql_demo;
+-----------------------------+---------+-------------+-------------+-------+
| Action | Ordinal | Target_Host | Target_Port | Phase |
+-----------------------------+---------+-------------+-------------+-------+
| COPY PARTITION | 13 | 127.0.0.1 | 10002 | 3 |
| COPY PARTITION | 2 | 127.0.0.1 | 10003 | 4 |
| COPY PARTITION | 2 | 127.0.0.1 | 10004 | 4 |
| PROMOTE PARTITION WITH DROP | 2 | 127.0.0.1 | 10003 | 5 |
| DROP PARTITION | 2 | 127.0.0.1 | 10002 | 6 |
| DROP PARTITION | 13 | 127.0.0.1 | 10004 | 6 |
+-----------------------------+---------+-------------+-------------+-------+Understanding the Rebalance Actions
Each action occurs on a single partition.
|
Action |
Definition |
|---|---|
|
|
Copies a partition and sets up replication to keep the copy in sync. |
|
|
Promotes a replica partition into a master partition. |
|
|
Drops a partition. |
Last modified: May 24, 2023