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
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
