In order to purge your DB from soft-deleted records, you need to move
the soft-deleted records from any table allowing them to the
corresponding shadow table so you could purge the shadow tables
eventually.
nova-manage db archive_deleted_rows is the command you're looking for.
** Changed in: nova
Status: New => Invalid
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1716593
Title:
reservations table in nova mysql db grows constantly
Status in OpenStack Compute (nova):
Invalid
Bug description:
In case if there are large amount of VMs on OpenStack, we observer
enormous growth of the nova.reservations table. The table is updated
every 60 seconds, and soft-deleted records never deleted from the
table. As a result this table could consume about 1/5 of space in
/var/lib/mysql.
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1716593/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
