Identifying and Reducing Memory Usage

An example of a typical question about memory usage is, "I only have 10GB of tables but I'm using 67GB of RAM? What is that additional memory being used for?"

SingleStore DB keeps detailed accounting of how memory is being used. You can run the command SHOW STATUS EXTENDED on an individual SingleStore DB instance to see a detailed break down of memory usage. You can also see this information in the Dashboard of the Studio UI, or if you navigate to the status page for a SingleStore DB instance. You can do this from the cluster view by clicking into an individual host and then further clicking into an individual SingleStore DB node.