← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1421089] Re: no any index for port DB sqlalchemy

 

** Changed in: neutron
       Status: Fix Committed => Fix Released

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1421089

Title:
  no any index for port DB sqlalchemy

Status in OpenStack Neutron (virtual network service):
  Fix Released

Bug description:
  Now there is not any index for port  DB sqlalchemy, but for nova bulk create VM, it frequently select port according to 'tenant_id','network_id' ,'device_id', if no index, it will consume much time in db operation, so I think it is better to add index for
  port 'tenant_id', 'network_id' ,'device_id'.

  'tenant_id' is added in
  https://bugs.launchpad.net/neutron/+bug/1419815.

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1421089/+subscriptions


References