EXPLAIN REBALANCE ALL DATABASES
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Returns the set of steps that REBALANCE ALL DATABASES
would run if you executed it now.
Syntax
EXPLAIN REBALANCE ALL DATABASES;
Example
EXPLAIN REBALANCE ALL DATABASES;
+----------+-----------------------------+---------+-------------+-------------+-------+-----------------------------+
| Database | Action | Ordinal | Target_Host | Target_Port | Phase | Estimated_Time_Remaining_Ms |
+----------+-----------------------------+---------+-------------+-------------+-------+-----------------------------+
| x_db | COPY PARTITION | 13 | 127.0.0.1 | 10002 | 3 | 7821 |
| x_db | COPY PARTITION | 2 | 127.0.0.1 | 10003 | 4 | 7821 |
| x_db | COPY PARTITION | 2 | 127.0.0.1 | 10004 | 4 | 7821 |
| x_db | PROMOTE PARTITION WITH DROP | 2 | 127.0.0.1 | 10003 | 5 | 1351 |
| x_db | DROP PARTITION | 2 | 127.0.0.1 | 10002 | 6 | 1002 |
| x_db | DROP PARTITION | 13 | 127.0.0.1 | 10004 | 6 | 1002 |
+----------+-----------------------------+---------+-------------+-------------+-------+-----------------------------+
Note: The Estimated_
is the estimated total time (in milliseconds) that each low-level command will take to complete.
The Ordinal is the target partition’s ordinal, and the Target_COPY PARTITION
on partitions test:1
and test:3
in parallel.Estimated_
is the estimated total time (in milliseconds) that each low-level command will take to complete.
Last modified: July 31, 2023