{question}
Is there a buffer pool in SingleStore?
{question}
{answer}
No. While some other database solutions use the buffer pool to cache table and index data, SingleStore keeps detailed accounting of how memory is being used with memory allocators. You can run the query SHOW STATUS EXTENDED on any given SingleStore node to see the breakdown of the memory allocators at that point in time.
The sum of the following memory allocators is equal to the value of Total_server_memory:
Alloc_table_autostats +
Alloc_thread_stacks +
Malloc_active_memory +
Buffer_manager_memory +
Total_io_pool_memory +
Alloc_large_variable +
Alloc_replication_large +
Alloc_durability_large +
Alloc_hash_buckets +
Alloc_mmap_memory +
Alloc_compiled_unit_sections +
Alloc_object_code_images +
Alloc_unit_ifn_thunks +
Alloc_unit_images =
Total_server_memory
For a more in-depth look at what each allocator measures, consult the Identifying and Reducing Memory Usage and SHOW STATUS EXTENDED documentation.
{answer}