© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
0e1f616
(Get the code!)
+1 for adding an index. My grizzly test environment was completely unstable (many services had begun to intermittently time out - error 504) due to slow keystone response. Doing a simple "SELECT COUNT(*) FROM token" would take nearly a minute (approximately 80,000 rows; the oldest expiration date was only 9 days ago). After I created an index ("ALTER TABLE token ADD INDEX IX_token_expires (expires);"), that same select query returned instantly. I'm only on migration 22.