yahoo-eng-team team mailing list archive

[侯喆 <1634746@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

When our keystone to valid token , it cost too much time on function
check_revocation.

In the path /keystone/revoke/backends/sql.py  func list_events()

>
events = [revoke_model.RevokeEvent(**e.to_dict()) for e in query]

It cost about 3 second and our database on revocation_event table has
38596 row.

Query sql from this table cost 0.01 second,but transfer this to a dict
cost 3s.

---------------
mysql> select count(*) from revocation_event;       
+----------+
| count(*) |
+----------+
|    38596 |
+----------+

** Affects: keystone
     Importance: Undecided
         Status: New

-- 
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/1634746

Title:
  check revocation too slow

Status in OpenStack Identity (keystone):
  New

Bug description:
  When our keystone to valid token , it cost too much time on function
  check_revocation.

  In the path /keystone/revoke/backends/sql.py  func list_events()

  >
  events = [revoke_model.RevokeEvent(**e.to_dict()) for e in query]

  It cost about 3 second and our database on revocation_event table has
  38596 row.

  Query sql from this table cost 0.01 second,but transfer this to a dict
  cost 3s.

  ---------------
  mysql> select count(*) from revocation_event;       
  +----------+
  | count(*) |
  +----------+
  |    38596 |
  +----------+

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