Comment 5 for bug 1506738

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to ceilometer (master)

Reviewed: https://review.openstack.org/235826
Committed: https://git.openstack.org/cgit/openstack/ceilometer/commit/?id=b9bf5f1f571f21aee4347c80a5a7ac8a1c456e45
Submitter: Jenkins
Branch: master

commit b9bf5f1f571f21aee4347c80a5a7ac8a1c456e45
Author: ZhiQiang Fan <email address hidden>
Date: Fri Oct 16 02:45:45 2015 -0700

    avoid generate temporary table when query samples

    Currently, when we call query-samples API, for SQL backend, we do
    an inner join to get a temporary table, then apply filters, orderby
    and limit options on it. Such implementation will drain disk space
    or cause timeout exception when data set is growing, even with specified
    limit and filters.

    This patch applies filters and limit on the inner join itself, and
    uses a fake mapper object instead of temporary table to suit current
    query transformer.

    Change-Id: I261a2dd362ed51c16a6fa191dadcce1b45fce2e4
    Closes-Bug: #1506738