[
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, unions, etc. 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()}}:
* 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
> 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, unions, etc. 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)
