** Changed in: nova
Status: Fix Committed => Fix Released
** Changed in: nova
Milestone: None => havana-3
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1203872
Title:
missing index on reservations.uuid
Status in OpenStack Compute (Nova):
Fix Released
Bug description:
In a large deployment we're getting entries in our slow query log for
querying the reservations table on the uuid column. An example is
# Time: 130722 19:01:43
# User@Host: nova_20130124[nova_20130124] @ [10.23.244.148]
# Query_time: 5.253471 Lock_time: 0.000084 Rows_sent: 3 Rows_examined:
1110157
SET timestamp=1374519703;
SELECT reservations.created_at AS reservations_created_at,
reservations.updated_at AS reservations_updated_at, reservations.deleted_at AS
reservations_deleted_at, reservations.deleted AS reservations_deleted,
reservations.id AS reservations_id, reservations.uuid AS reservations_uuid,
reservations.usage_id AS reservations_usage_id, reservations.project_id AS
reservations_project_id, reservations.resource AS reservations_resource,
reservations.delta AS reservations_delta, reservations.expire AS
reservations_expire
FROM reservations
WHERE reservations.deleted = 0 AND reservations.uuid IN
('33c6c791-72f8-48f2-b0ee-47c6084d2956',
'ad642dc9-1faf-4906-859c-b9563491fdd2', '29f8f769-a6bc-4a23-8bdb-29900f872d3a')
FOR UPDATE;
This comes from the _quota_reservations_query method used by
reservation_commit and reservation_rollback.
There should be an index on reservations.uuid.
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1203872/+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
