[
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()}}:
* 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
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)).
> 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()}}:
> * 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
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
