Missing index on allocated
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
neutron |
Fix Released
|
Medium
|
Elena Ezhova |
Bug Description
ml2_vxlan_
These tables frequently used by similar queries:
SELECT ml2_vxlan_
This does select without an index, which causes very poor performance.
If Transaction which involved in allocation took long time, in parallel can lead to an allocation failure and retry.
These tables needs to have index on the 'allocated' field.
In the ml2_vlan_
description: | updated |
Changed in neutron: | |
assignee: | nobody → Elena Ezhova (eezhova) |
tags: | added: db |
Changed in neutron: | |
importance: | Undecided → Medium |
status: | New → Confirmed |
Changed in neutron: | |
milestone: | none → kilo-2 |
status: | Fix Committed → Fix Released |
Changed in neutron: | |
milestone: | kilo-2 → 2015.1.0 |
Fix proposed to branch: master /review. openstack. org/148617
Review: https:/