[Openstack-operators] How do you handle purge of database tables ?

Abel Lopez alopgeek at gmail.com
Wed Jun 22 22:03:17 UTC 2016


Some projects (e.g. cinder) have tools..
`cinder-manage db-purge` or maybe it's "db purge" or something along those
lines...
It was around Kilo when that got added.

Otherwise, in the past, I've done
mysql backup, then a massive table by table purge of "deleted=1" rows.

On Wed, Jun 22, 2016 at 2:39 PM, Gilles Mocellin <
gilles.mocellin at nuagelibre.org> wrote:

> Le 22/06/2016 à 23:26, Gilles Mocellin a écrit :
>
>> Hello,
>>
>> While digging in nova's database, I found that many objects ar not really
>> deleted, but instead just marked deleted.
>> In fact, it's a general behavior in other projects (cinder, glance...).
>>
>> I understand that. It can be handy.
>>
>> But, is there a way to handle regular purging of theses elements inside
>> OpenStack configuration ?
>>
>> Or do we, operators, have to create batchs to purge all that ?
>>
>>
> I've found some blueprints indicating that there nothing for now, inside
> OpenStack :
>
> https://blueprints.launchpad.net/nova/+spec/purge-deleted-instances-cmd
> https://blueprints.launchpad.net/cinder/+spec/database-purge
> https://blueprints.launchpad.net/glance/+spec/database-purge
>
>
>
> _______________________________________________
> OpenStack-operators mailing list
> OpenStack-operators at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20160622/4bbfb617/attachment.html>


More information about the OpenStack-operators mailing list