← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1582585] Re: the speed of query user from ldap server is very slow

 

Reviewed:  https://review.openstack.org/328820
Committed: https://git.openstack.org/cgit/openstack/keystone/commit/?id=53bb53a814324234aa4b798651a616e310396221
Submitter: Jenkins
Branch:    master

commit 53bb53a814324234aa4b798651a616e310396221
Author: liuhongjiang <andrew.lhj@xxxxxxxxx>
Date:   Mon Jun 13 08:11:16 2016 +0800

    Added cache for id mapping manager
    
    When using a identity driver without providing uuid, and using default
    sql id mapping driver, if there are lots of users, then it may take
    minutes to list users. Adding cache to the id mapping manager can
    improve the performance.
    
    After adding the cache, when listing 12000 users though the keystone
    api, and the time is reduced from about 75 seconds to 20 seconds.
    
    Closes-Bug: #1582585
    Change-Id: I72eeb88926d8babb09a61e99f6f594371987f393


** Changed in: keystone
       Status: In Progress => Fix Released

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Identity (keystone).
https://bugs.launchpad.net/bugs/1582585

Title:
  the speed of query user from ldap server is very slow

Status in OpenStack Identity (keystone):
  Fix Released

Bug description:
  In our project, the speed of query user from ldap server is very
  slow,our ldap user number is 12,000,the query costs almost 45 seconds

  The reason is that keystone will generate the uuid for the ldap users one by one and insert db.And second query time later,it also goes to db,not use the cache.
  So adding the cache to improve the query speed

  After adding @MEMOIZE to the following function
  https://github.com/openstack/keystone/blob/master/keystone/identity/core.py#L580.
  First query time almost costs 50 seconds,but second query time later it only costs 7 seconds.

  So it is very necessary to improve this feature

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


References