Public bug reported:
We are using Openstack Train
When using the command
./nova-manage db archive_deleted_rows --all-cells --verbose --before
2021-05-01 --max_rows 1000 --purge
This run takes 19 minutes, without the --before option, this command
gets down to seconds.
It turns out when I look into the indexes of the tables I'm missing a
index on the deleted_at column.
For example when I use the SQL command:
SHOW INDEX FROM nova.instances;
I'm missing the index.
** Affects: nova
Importance: Undecided
Status: New
--
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/1929563
Title:
Missing database index deleted_at column
Status in OpenStack Compute (nova):
New
Bug description:
We are using Openstack Train
When using the command
./nova-manage db archive_deleted_rows --all-cells --verbose --before
2021-05-01 --max_rows 1000 --purge
This run takes 19 minutes, without the --before option, this command
gets down to seconds.
It turns out when I look into the indexes of the tables I'm missing a
index on the deleted_at column.
For example when I use the SQL command:
SHOW INDEX FROM nova.instances;
I'm missing the index.
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1929563/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
