ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nikolay Izhikov (Jira)" <j...@apache.org>
Subject [jira] [Comment Edited] (IGNITE-12393) Striped thread pool queue system view
Date Mon, 02 Dec 2019 08:01:00 GMT

    [ 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)

Mime
View raw message