]> review.fuel-infra Code Review - openstack-build/cinder-build.git/commit
Code Review / openstack-build / cinder-build.git / commit
? search:
summary | shortlog | log | commit | commitdiff | review | tree
(parent: 2f09c30) | patch
Add index for reservations on (deleted, expire)
authorVishvananda Ishaya <vishvananda@gmail.com>
Fri, 25 Jul 2014 17:15:27 +0000 (10:15 -0700)
committerVishvananda Ishaya <vishvananda@gmail.com>
Fri, 25 Jul 2014 17:15:27 +0000 (10:15 -0700)
commit4d56b91628518629b47997b93acd9cb1e48f87f5
treee754495d343c70976fa8b1b9d2598a16b6bbaae3tree | snapshot
parent2f09c3031ef2d2db598ec4c56f6127e33d29b2cccommit | diff
Add index for reservations on (deleted, expire)

the query for expire_reservations currently does a full table scan.
This adds an index so frequent invocations of expire does not bog
down the database.

Change-Id: Ic6f6e4262746753d869ad37b8aaaa5ffc1c4efef
Resolves-bug: 1348720
cinder/db/sqlalchemy/migrate_repo/versions/023_add_expire_reservations_index.py [new file with mode: 0644] blob
cinder/tests/test_migrations.py diff | blob | history