← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1716593] Re: reservations table in nova mysql db grows constantly

 

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


References