[
https://issues.apache.org/jira/browse/IGNITE-4757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Denis Magda updated IGNITE-4757:
--------------------------------
Description:
SQL queries monitoring part has to be improved. Suggest adding the metrics
below.
Per-query metrics. Total history size is defined by
{{CacheConfiguration.getQueryDetailMetricsSize()}}:
* Total query execution count.
* Query execution time - min, max, avg. Provide a breakdown for map, per-join
and reduce phases.
* A number of bytes exchanged between nodes during query execution. Provide a
per-join breakdown.
* A number rows returned - min, max, avg.
* Collocated or non-collocated query.
In addition, we need to introduce a way to filter out metrics for queries that
complete faster than some predefined NNN time.
Finally, research a possibility to put the metrics into the H2 execution plan.
Create a separated ticket if this task in not completed under this ticket.
Discussion on the dev list:
http://apache-ignite-developers.2346864.n4.nabble.com/Additional-SQL-metrics-td14945.html
was:
SQL queries monitoring part has to be improved. Suggest adding the metrics
below.
Per-query metrics. Total history size is defined by
{{CacheConfiguration.getQueryDetailMetricsSize()}}:
* if a query was executed in the collocated or non-collocated mode. Three
results are valid: collocated, non-collocated, simple query (no joins).
* non-collocated query: size of the data exchanged between the nodes to
complete a specific join. If there are multiple joins in the query we need to
provide this metric for every of them.
* non-collocated query: did a query do broadcast or unicast to get data needed
to complete a join. If there are multiple joins in the query we need to provide
this metric for every of them.
* non-collocated and collocated query: a part of the time spent joining the
data. If there are multiple joins in the query we need to provide this metric
for every of them.
CacheMetrics:
* an average number of executed SQL queries (collocated, non-collocated, simple
query (no joins)).
Discussion from the dev list:
http://apache-ignite-developers.2346864.n4.nabble.com/Additional-SQL-metrics-td14945.html
> SQL Joins Metrics
> -----------------
>
> Key: IGNITE-4757
> URL: https://issues.apache.org/jira/browse/IGNITE-4757
> Project: Ignite
> Issue Type: Task
> Reporter: Denis Magda
>
> SQL queries monitoring part has to be improved. Suggest adding the metrics
> below.
> Per-query metrics. Total history size is defined by
> {{CacheConfiguration.getQueryDetailMetricsSize()}}:
> * Total query execution count.
> * Query execution time - min, max, avg. Provide a breakdown for map, per-join
> and reduce phases.
> * A number of bytes exchanged between nodes during query execution. Provide a
> per-join breakdown.
> * A number rows returned - min, max, avg.
> * Collocated or non-collocated query.
> In addition, we need to introduce a way to filter out metrics for queries
> that complete faster than some predefined NNN time.
> Finally, research a possibility to put the metrics into the H2 execution
> plan. Create a separated ticket if this task in not completed under this
> ticket.
> Discussion on the dev list:
> http://apache-ignite-developers.2346864.n4.nabble.com/Additional-SQL-metrics-td14945.html
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
