Removes orphaned partitions. Orphaned partitions are partition databases on leaf nodes that are no longer considered part of the cluster.

Syntax

CLEAR ORPHAN DATABASES;

Remarks

• The master aggregator avoids dropping orphan partition databases as a safeguard, in case this data is needed.

• To detect orphan partitions, run SHOW CLUSTER STATUS and check for partitions with the role of Orphan.

• Before running CLEAR ORPHAN DATABASES, run: EXPLAIN CLEAR ORPHAN DATABASES; to see which partitions will be dropped.

Related Topics

• SHOW CLUSTER STATUS
• EXPLAIN

Was this Article Helpful?

Thanks For Your Feedback!