buffer_ manager_ cached_ memory
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
Warning
This value cannot be modified by users.
SingleStore caches memory (allocated by the Buffer Manager) that is not in use, instead of returning it to the system.buffer_
variable keeps a track of this cached memory.
SHOW STATUS EXTENDED LIKE 'buffer_manager_cached%';
+------------------------------+---------+
| Variable_name | Value |
+------------------------------+---------+
| Buffer_manager_cached_memory | 80.0 MB |
+------------------------------+---------+
buffer_
has following limitations:
-
buffer_
is capped at 25% of themanager_ cached_ memory maximum_
.memory -
Buffers will only be cached if the
total_
is less than 90% of theserver_ memory maximum_
memory
For more information on buffer_
and total_
, see the Summary variables topic.
Last modified: June 22, 2022