v.24.3New Feature

Size-Capped Memory Tables with Configuration Settings

Size-capped Memory tables: controlled by their settings, min_bytes_to_keep, max_bytes_to_keep, min_rows_to_keep and max_rows_to_keep. #60612 (Jake Bamrah).
Size-capped <code>Memory</code> tables with configurable settings to limit memory and row usage.

Why it matters

This feature introduces memory and row caps for <code>Memory</code> tables through the new settings <code>min_bytes_to_keep</code>, <code>max_bytes_to_keep</code>, <code>min_rows_to_keep</code>, and <code>max_rows_to_keep</code>. It helps manage resource consumption by controlling how much data is retained in memory tables, preventing unbounded growth and potential memory exhaustion.

How to use it

To enable size limits on <code>Memory</code> tables, configure the table-specific or global settings <code>min_bytes_to_keep</code>, <code>max_bytes_to_keep</code>, <code>min_rows_to_keep</code>, and <code>max_rows_to_keep</code>. These settings define minimum and maximum thresholds for memory size and row count, allowing you to fine-tune retention according to your workload requirements.