Inconsistent database indexes exist in mysql and other databases
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Compute (nova) |
Confirmed
|
Wishlist
|
Unassigned |
Bug Description
A lot of database indexes are created for mysql in db migrating file 216_havana.py (see mysql_pre_indexes), and the part of indexes are added in 271_sqlite_
It cause an issue, the huge performance difference exists when we use different type databases (for example: mysql, postgresql).
At least, we should keep the consistent indexes in all supported databases.
Changed in nova: | |
assignee: | nobody → Shuquan Huang (shuquan) |
tags: | added: db performance |
Changed in nova: | |
status: | New → Confirmed |
importance: | Undecided → Wishlist |
Changed in nova: | |
assignee: | Shuquan Huang (shuquan) → nobody |