REBALANCE ALL DATABASES

On this page

The REBALANCE ALL DATABASES command rebalances the partitions on all databases in the cluster.

Syntax

REBALANCE ALL DATABASES[KILL];

Remarks

  • This command runs REBALANCE PARTITIONS ... FULL on each database in the cluster, in alphabetical order of the database name. When REBALANCE PARTITIONS ... FULL runs on a database d, it first considers the placement of the partitions of the other databases in the cluster before rebalancing the partitions of d. Refer to REBALANCE PARTITIONS for an example of REBALANCE PARTITIONS ... FULL.

  • If MemSQL Ops is not enabled for manual cluster control, then a REMOVE LEAF can result in the leaf being added back without user intervention.

  • To see the status of running this command, run SHOW REBALANCE ALL DATABASES STATUS. You can also run EXPLAIN REBALANCE ALL DATABASES to see the series of steps that the command REBALANCE ALL DATABASES would run, if you executed it.

Last modified:

Was this article helpful?