Search code examples
singlestore

How to fix the number of CPUs used by MemSQL?

I am running MemSQL(1 agg and 5 leaf nodes) on a single box which has 2 TB of RAM.

However this is a shared system and there are other processes running on it. When I deploy the cluster and run few queries, the CPU utilization goes really high and looks like it uses all the cores. Is there a way I can prevent this happening by specifying the number of cores to use?

I checked the documents and there is a paramter called maximum_memory which is set by default to 90% of the host memory. Is this the parameter that needs to be changed?

Solution

  • There is no MemSQL configuration option to limit the number of cores. The cpu utilization decrease you observed from reducing your maximum_memory is indicative of the system using less machine resources overall (you reduced memory availablilty to the system by 80%).

    If you want to limit the number of CPUs being used by MemSQL, use taskset.