Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

REBALANCE ALL DATABASES

Info

SingleStore Managed Service does not support this command.

Rebalances the partitions on all databases in the cluster.

Syntax

REBALANCE ALL DATABASES;

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.
  • 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.