Freeing Table 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.
Table memory can only be freed back to the system when large chunks of data is deleted.
Currently, there is no method or allocator to track the real memory use
versus free memory but still allocated to SingleStore
.OPTIMIZE TABLE.
command moves rows from partially-full chunks of memory in order to consolidate the data into full and empty chunks, thus allowing the newly-created empty chunks to be freed back to the system.used by SingleStore
memory and the free system memory is as accurate as possible, and can be referred to know the amount of free memory available on the hosts.
Last modified: June 22, 2022