[teiid-issues] [JBoss JIRA] (TEIID-4557) Enable memory management at the query level

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13316976#comment-13316976 ] 

Steven Hawkins commented on TEIID-4557:
---------------------------------------

Memory is too loosely defined here.  Are we talking about heap, disk, or total.  

Also the notion of per view doesn't generally make sense as view layers are typically optimized out.  If we are talking specifically about materialization, then this could apply to internal.  You can currently give a preference on an internal materialized view pages being held in memory, but otherwise we don't currently have limits.  I'd consider this a low priority given that global limits could be worked first.

> Would it also be possible to set a global memory limit for the execution of any query in the server or in a particular VDB.

I'm assuming this means disk consumption.  There's no hard limit on disk consumption on a query/session basis.  We currently track by operation (grouping/sort/etc.), which would an easy point to enforce in terms.  Tracking on session or query will take more work.

> This provides a simple and general setting to guarantee no query can monopolize server resources

It should be noted that there's lots of code that enforces fair resource consumption in terms of heap memory that can be reserved, thread utilization (including time-slicing), etc. 

> Enable memory management at the query level
> -------------------------------------------
>
>                 Key: TEIID-4557
>                 URL: https://issues.jboss.org/browse/TEIID-4557
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Server
>            Reporter: Van Halbert
>            Assignee: Steven Hawkins
>             Fix For: 9.2
>
>
> Allows managing (and limiting if needed) the memory consumed by the execution of a particular view.  Maybe this can be done through a max. memory and swapping settings on the view. 
> Would it also be possible to set a global memory limit for the execution of any query in the server or in a particular VDB. This provides a simple and general setting to guarantee no query can monopolize server resources



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)