CLEAR ORPHAN DATABASES

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

Alert

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

Was this article useful?