DB Prune

Balázs Gibizer balazs.gibizer at est.tech
Wed Aug 26 12:15:29 UTC 2020

On Wed, Aug 26, 2020 at 06:57, "Szabo, Istvan (Agoda)" 
<Istvan.Szabo at agoda.com> wrote:
> Hi,
>  We have a cluster where the user continuously spawn and delete 
> servers which makes the db even in compressed state 1.1GB.
>  I’m sure it has a huge amount of trash because this is a cicd 
> environment and the prod just uses 75MB.
>  How is it possible to cleanup the db on a safe way, what should be 
> the steps?

 From Nova perspective you can get rid of the data of the already 
deleted instances via the following two commands:

nova-manage db archive_deleted_rows
nova-manage db purge



>  Best regards,
>  Istvan
> This message is confidential and is for the sole use of the intended 
> recipient(s). It may also be privileged or otherwise protected by 
> copyright or other legal rules. If you have received it by mistake 
> please let us know by reply email and delete it from your system. It 
> is prohibited to copy this message or disclose its content to anyone. 
> Any confidentiality or privilege is not waived or lost by any 
> mistaken delivery or unauthorized disclosure of the message. All 
> messages sent to and from Agoda may be monitored to ensure compliance 
> with company policies, to protect the company's interests and to 
> remove potential malware. Electronic messages may be intercepted, 
> amended, lost or deleted, or contain viruses.

More information about the openstack-discuss mailing list