Comment 5 for bug 1060363

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to nova (stable/folsom)

Reviewed: https://review.openstack.org/16045
Committed: http://github.com/openstack/nova/commit/34c3845513ab938edae7b81042c44419a6ca00ac
Submitter: Jenkins
Branch: stable/folsom

commit 34c3845513ab938edae7b81042c44419a6ca00ac
Author: Johannes Erdfelt <email address hidden>
Date: Tue Oct 2 17:55:00 2012 +0000

    Make resource tracker uses faster DB query

    Fixes bug 1060363

    db.instance_get_all_by_filters() uses a regex when filtering on host,
    which will do a full table scan. A regex isn't needed and instead,
    db.instance_get_all_by_host() can be used which does not impact the
    performance so much.

    Change-Id: I812e1d5320763e5c65232351e1e21285e04e6a4b