Configure the Retention Period for an Unlimited Storage Database


Unlimited storage databases are not available in all editions of SingleStore. For more information, see SingleStore Editions.

The engine variable bottomless_gc_retention_period_minutes specifies how long historical information used to enable point-in-time recovery (PITR) is retained. The default value of is 1440 minutes. To override the default value, set the engine variable. For example, to set to the value to 3000 minutes:

SET GLOBAL bottomless_gc_retention_period_minutes = 3000;

Once a milestone reaches the retention period set by bottomless_gc_retention_period_minutes, it will no longer be available and will not appear in the MV_MILESTONES information schema table.

You cannot attach an unlimited storage database at a milestone or time that is not within the retention period. For example, suppose bottomless_gc_retention_period_minutes is 1440 minutes (1 day). On June 1 you create a milestone for a database d. On June 3, you would not be able to attach d at the milestone created on June 1 or at a point in time that occurred on June 1.

Last modified: May 5, 2023

Was this article helpful?