yahoo-eng-team team mailing list archive

[Henry Nash <henryn@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

The assignment call list_projects_for_user() is commonly used - not
least every time you issue a scoped token.  Ina test configuration,
this method was consuming 36% of all keystone clock time.  This call
searches the assignments table (which has one row for every assignment)
by actor_id.  Although actor_id is part of a composite primary key, when
used alone it is like any other non-indexed column.

Adding an index for actor ID would significantly improve performance,
and since the read of such a table is probably much more frequency than
new role assignment being added, this seems like a good trade-off.

Such an index would also improve the performance of get
role_assignments, when used to get role assignments for a user - which
would seem a likely common usage pattern

** Affects: keystone
     Importance: Undecided
         Status: New

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

Title:
  Performance of list_projects_for_user impacting keystone

Status in OpenStack Identity (Keystone):
  New

Bug description:
  The assignment call list_projects_for_user() is commonly used - not
  least every time you issue a scoped token.  Ina test configuration,
  this method was consuming 36% of all keystone clock time.  This call
  searches the assignments table (which has one row for every
  assignment) by actor_id.  Although actor_id is part of a composite
  primary key, when used alone it is like any other non-indexed column.

  Adding an index for actor ID would significantly improve performance,
  and since the read of such a table is probably much more frequency
  than new role assignment being added, this seems like a good trade-
  off.

  Such an index would also improve the performance of get
  role_assignments, when used to get role assignments for a user - which
  would seem a likely common usage pattern

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