Timeout on API when it tries to check user auth token

[Ursula Junque]

We had several timeouts on 03/03, about 250. It seems it's timing out when trying to get the auth token for the user, as seen on OOPS-1158ED128, OOPS-1158ED332 and OOPS-1158ED133.

[Francis J. Lacoste (flacoste)]

I think we are missing an index since we changed the query from nonce, token, to nonce, token, timestamp.

I think we could remove the oauthnonce_nonce_token_key index and create a new one.

[Francis J. Lacoste (flacoste)]

I've requested a prune of the OAuthNonce table, that should alleviate the problem until we put the index in.

[Stuart Bishop (stub)]

Pruned and a temporary index put in place.