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.
Reviewed: https:/ /review. openstack. org/235826 /git.openstack. org/cgit/ openstack/ ceilometer/ commit/ ?id=b9bf5f1f571 f21aee4347c80a5 a7ac8a1c456e45
Committed: https:/
Submitter: Jenkins
Branch: master
commit b9bf5f1f571f21a ee4347c80a5a7ac 8a1c456e45
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: I261a2dd362ed51 c16a6fa191dadcc e1b45fce2e4
Closes-Bug: #1506738