Removing Orphaned Partitions that are not Needed
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
If you have orphaned partitions that you no longer need, you can remove all of them at once.
EXPLAIN CLEAR ORPHAN DATABASES;
To remove all orphaned partitions, run
CLEAR ORPHAN DATABASES;
Make sure to have run SHOW PARTITIONS
and SHOW CLUSTER STATUS
and have verified that all partitions are accounted for before doing this.
Note: CLEAR ORPHAN DATABASES
can’t be undone.
Last modified: July 5, 2021