Another vote of confidence for the script that Tim has mentioned with regards to clearing down Nova’s DB. I blogged a bit about the process and the results here:
http://dischord.org/2015/12/30/archiving-data-in-nova-s-database/ <http://dischord.org/2015/12/30/archiving-data-in-nova-s-database/> — -Nick > On 23 Jun 2016, at 06:53, Tim Bell <[email protected]> wrote: > > There are also some tools in the OSOps repository (Nova for example has > https://github.com/openstack/osops-tools-generic/tree/master/nova) > <https://github.com/openstack/osops-tools-generic/tree/master/nova)> > > Tim > > From: Abel Lopez <[email protected]> > Date: Thursday 23 June 2016 at 00:03 > To: Gilles Mocellin <[email protected]> > Cc: openstack-operators <[email protected]> > Subject: Re: [Openstack-operators] How do you handle purge of database tables > ? > >> 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 >> <[email protected] <mailto:[email protected]>> >> 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/nova/+spec/purge-deleted-instances-cmd> >>> https://blueprints.launchpad.net/cinder/+spec/database-purge >>> <https://blueprints.launchpad.net/cinder/+spec/database-purge> >>> https://blueprints.launchpad.net/glance/+spec/database-purge >>> <https://blueprints.launchpad.net/glance/+spec/database-purge> -- DataCentred Limited registered in England and Wales no. 05611763
_______________________________________________ OpenStack-operators mailing list [email protected] http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
