[
https://issues.jboss.org/browse/TEIID-4557?page=com.atlassian.jira.plugin...
]
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)