← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1419816] [NEW] Speed up SELECTs with filters by tenant_id

 

Public bug reported:

Adding index on tenant_id could greatly speed up SELECTs with filters by tenant_id when some value is selected per resource
per tenant.

Simple example with adding index on securitygrouprules show that speed could increase twice.
For  MySQL http://paste.openstack.org/show/169810/
For PostgreSQL http://paste.openstack.org/show/169957/

** Affects: neutron
     Importance: Undecided
     Assignee: Ann Kamyshnikova (akamyshnikova)
         Status: New


** Tags: db

** Changed in: neutron
     Assignee: (unassigned) => Ann Kamyshnikova (akamyshnikova)

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

Title:
  Speed up SELECTs with filters by tenant_id

Status in OpenStack Neutron (virtual network service):
  New

Bug description:
  Adding index on tenant_id could greatly speed up SELECTs with filters by tenant_id when some value is selected per resource
  per tenant.

  Simple example with adding index on securitygrouprules show that speed could increase twice.
  For  MySQL http://paste.openstack.org/show/169810/
  For PostgreSQL http://paste.openstack.org/show/169957/

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


Follow ups

References