v.24.3New Feature
Size-Capped Memory Tables with Configuration Settings
Size-cappedMemorytables: controlled by their settings,min_bytes_to_keep, max_bytes_to_keep, min_rows_to_keepandmax_rows_to_keep. #60612 (Jake Bamrah).
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.