CLEAR ORPHAN DATABASES
Removes orphaned partitions. Orphaned partitions are partition databases on leaf nodes that are no longer considered part of the cluster.
CLEAR ORPHAN DATABASES;
This command cannot be undone.
The master aggregator avoids dropping orphan partition databases as a safeguard, in case this data is needed.
To detect orphan partitions, run
SHOW CLUSTER STATUSand check for partitions with the role of
CLEAR ORPHAN DATABASES, run:
EXPLAIN CLEAR ORPHAN DATABASES;to see which partitions will be dropped.