[
https://issues.apache.org/jira/browse/IGNITE-12393?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16985882#comment-16985882
]
Nikolay Izhikov edited comment on IGNITE-12393 at 12/2/19 8:00 AM:
-------------------------------------------------------------------
[~zstan] Thanks for the feedback.
> tx lock, aquire, commit phases log, who takes long lock,
I think this should be covered with a tracing feature.
> long queries
We already have {{SYS.SQL_QUERIES}}, {{SYS.SCAN_QUERIES}},
{{SYS.SQL_QUERIES_HISTORY}}.
these views provide data similar to what you expected.
Can you, please, take a look at this view?
https://github.com/apache/ignite/blob/master/modules/core/src/main/java/org/apache/ignite/spi/systemview/view/SqlQueryView.java
https://github.com/apache/ignite/blob/master/modules/core/src/main/java/org/apache/ignite/spi/systemview/view/SqlQueryHistoryView.java
https://github.com/apache/ignite/blob/master/modules/core/src/main/java/org/apache/ignite/spi/systemview/view/ScanQueryView.java
was (Author: nizhikov):
[~zstan] Thanks for the feedback.
> tx lock, aquire, commit phases log, who takes long lock,
I think this should be covered with a tracing feature.
> long queries
We already have {SYS.SQL_QUERIES}, {SYS.SCAN_QUERIES},
{SYS.SQL_QUERIES_HISTORY}.
these views provide data similar to what you expected.
Can you, please, take a look at this view?
https://github.com/apache/ignite/blob/master/modules/core/src/main/java/org/apache/ignite/spi/systemview/view/SqlQueryView.java
https://github.com/apache/ignite/blob/master/modules/core/src/main/java/org/apache/ignite/spi/systemview/view/SqlQueryHistoryView.java
https://github.com/apache/ignite/blob/master/modules/core/src/main/java/org/apache/ignite/spi/systemview/view/ScanQueryView.java
> Striped thread pool queue system view
> -------------------------------------
>
> Key: IGNITE-12393
> URL: https://issues.apache.org/jira/browse/IGNITE-12393
> Project: Ignite
> Issue Type: Sub-task
> Reporter: Nikolay Izhikov
> Assignee: Nikolay Izhikov
> Priority: Major
> Labels: IEP-35
> Fix For: 2.8
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> When in the production environment exist some cluster performance issues
> usually it leads to the large striped executor queue size.
> The number of tasks in the queue can observe by
> {StripedExecutorMXBean#getTotalQueueSize} metric. In the case queue size
> becomes large it's useful to have the ability to know what tasks are waiting
> for execution in the thread pool.
> Especially, for dealing with failover scenarios.
> We should create a system views to expose information about striped executor
> services queue.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
