Missing database index deleted_at column
Bug #1929563 reported by
masterpe
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Compute (nova) |
In Progress
|
Medium
|
masterpe |
Bug Description
We are using Openstack Train
When using the command
./nova-manage db archive_
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.
Changed in nova: | |
assignee: | nobody → masterpe (michiel-y) |
importance: | Undecided → Medium |
tags: | added: nova-manage |
To post a comment you must log in.
Fix proposed to branch: master /review. opendev. org/c/openstack /nova/+ /792989
Review: https:/