yahoo-eng-team team mailing list archive

[Dolph Mathews <1292720@xxxxxxxxxxxxxxxxxx>]

The id column is already the PK, which is always indexed.

** Changed in: keystone
       Status: New => Invalid

-- 
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):
  Invalid

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