[teiid-issues] [JBoss JIRA] (TEIID-2410) add tuning for lots of active plans

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-2410:
----------------------------------

    Description: When an active plan is not processing it will still be holding memory against the buffer manager reserve count.  (was: When an active plan is not processing it will still be holding memory against the buffer manager reserve count.  Also even non-active, but not closed plans can still hold their reservation even though a batch may not be held by the workitem.)


I made an initial misdiagnosis here.  non-active plans are not holding their reserves - even if they are holding a batch for the forward only logic (which seems like we need to account for).  The real problem was that with useCallingThread=false and plans that cause output buffer blocking we will not have the proper number of worker threads active, which will slow processing to a crawl as new plans back-up waiting for older plans to finish processing.
                
> add tuning for lots of active plans
> -----------------------------------
>
>                 Key: TEIID-2410
>                 URL: https://issues.jboss.org/browse/TEIID-2410
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>
> When an active plan is not processing it will still be holding memory against the buffer manager reserve count.

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