[Openstack] Slow API operations

Clint Byrum clint at fewbar.com
Tue Sep 3 19:12:51 UTC 2013

Excerpts from Guilherme Russi's message of 2013-09-03 11:52:39 -0700:
> Query OK, 502150 rows affected (32 min 2.77 sec) and nothing has changed,
> lol.

There's also indexes in Havana that help a lot, you might consider adding
them manually:

ALTER TABLE token ADD INDEX ix_token_valid (valid);
ALTER TABLE token ADD INDEX ix_token_expires (expires);

Note that a 500,000 row delete is _brutal_ on your server. We use this
in TripleO:


It allows space in between the deletes for other things to happen,
and also deletes in a more efficient way to not thrash around the table
deleting things in index order.

Also, if you don't need the content of your token table for audit purposes
and you can afford the RAM, you should definitely consider switching to
the memcached backend for tokens. If you do want to stay with the SQL
backend, make sure your MySQL is tuned for tons of tiny transactions
and has enough memory to keep the working set in RAM.

More information about the Openstack mailing list