commit 1cbe702e846d0dd0ffd53b67e257452c799c9e1d
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
(cherry picked from commit b9bf5f1f571f21aee4347c80a5a7ac8a1c456e45)
Reviewed: https:/ /review. openstack. org/239431 /git.openstack. org/cgit/ openstack/ ceilometer/ commit/ ?id=1cbe702e846 d0dd0ffd53b67e2 57452c799c9e1d
Committed: https:/
Submitter: Jenkins
Branch: stable/kilo
commit 1cbe702e846d0dd 0ffd53b67e25745 2c799c9e1d
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 ee4347c80a5a7ac 8a1c456e45)
Closes-Bug: #1506738
(cherry picked from commit b9bf5f1f571f21a