yahoo-eng-team team mailing list archive

[Kevin Fox <Kevin.Fox@xxxxxxxx>]

Public bug reported:

I see lots of load on our keystone mysql database. We are going to up
the revocation list timeout, but this query also looks like it would
benefit greatly from an index on token.id where it is iterating over
constantly:

| 5144 | keystone | c0:34909 | keystone | Query   |    2 | Sending data | SELECT token.id AS token_id, token.expires AS token_expires, token.extra AS token_extra, token.valid AS token_valid, token.user_id AS token_user_id, token.trust_id AS token_trust_id 
FROM token 
WHERE token.id = '8e58465a200bd0d893ccfd1f4716eb40' |

Our system is RDO Havana. I find no indexes on id in trunk though.

** 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/1292720

Title:
  index on token id

Status in OpenStack Identity (Keystone):
  New

Bug description:
  I see lots of load on our keystone mysql database. We are going to up
  the revocation list timeout, but this query also looks like it would
  benefit greatly from an index on token.id where it is iterating over
  constantly:

  | 5144 | keystone | c0:34909 | keystone | Query   |    2 | Sending data | SELECT token.id AS token_id, token.expires AS token_expires, token.extra AS token_extra, token.valid AS token_valid, token.user_id AS token_user_id, token.trust_id AS token_trust_id 
  FROM token 
  WHERE token.id = '8e58465a200bd0d893ccfd1f4716eb40' |

  Our system is RDO Havana. I find no indexes on id in trunk though.

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