Feature #10199
implement a temp-table size limit such that usage above that limit is backed by disk instead of memory
Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
Due date:
% Done:
0%
billable:
No
vendor_id:
GCD
case_num:
version_reported:
version_resolved:
reviewer:
production:
No
env_name:
topics:
Related issues
History
#1 Updated by Greg Shah about 1 year ago
Unlimited temp-table usage causes an OOME for the server. OE "spills" to disk when temp-table usage is too large. We need to implement a similar limit.
H2 has an option to be backed by disk but we will likely need to implement this ability to activate it on demand for a specific session. We would also need to track the temp-table memory usage by session.
#2 Updated by Alexandru Lungu about 1 year ago
- Related to Feature #10270: implement some temp-tables using the persistent database instance when they are joined to tables in that database added