[teiid-issues] [JBoss JIRA] (TEIID-2408) statistics of teiid query queuing information

[Ramesh Reddy (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramesh Reddy resolved TEIID-2408.
---------------------------------

    Resolution: Done


Added 
# active-plans-count => Current active plans in query engine
# waiting-plans-count => Waiting plans to process in queue
# max-waitplan-watermark => Max amount time any plan waited in queue
# avg-waitplan-time-milli => avg amount time the plans that were added wait queue, has spent in the queue waiting

{code}
[standalone at localhost:9999 /] /subsystem=teiid:engine-statistics
{
    "outcome" => "success",
    "result" => {
        "session-count" => 25,
        "total-memory-inuse-kb" => 0L,
        "total-memory-inuse-active-plans-kb" => 1470L,
        "buffermgr-disk-write-count" => 0L,
        "buffermgr-disk-read-count" => 0L,
        "buffermgr-cache-write-count" => 0L,
        "buffermgr-cache-read-count" => 0L,
        "buffermgr-diskspace-used-mb" => 0L,
        "active-plans-count" => 2,
        "waiting-plans-count" => 0,
        "max-waitplan-watermark" => 0,
        "avg-waitplan-time-milli" => 0L
    }
}
{code}
                
> statistics of teiid query queuing information
> ---------------------------------------------
>
>                 Key: TEIID-2408
>                 URL: https://issues.jboss.org/browse/TEIID-2408
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: AdminApi
>    Affects Versions: 8.2
>            Reporter: Jack Ma
>            Assignee: Ramesh Reddy
>             Fix For: 8.3
>
>
> At currently version of teiid, there is no teiid queuing information available from either teiid api or log or jmx, like how many query plans are still in the waiting queue, how many are in the active queue etc. .Thinking those queuing information is pretty critical for performance tuning up, 
> Based on the Ramesh's suggestion, creating this request for probably a statistics max water mark in the waiting queue, and average time spent in waiting queue etc.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira