Cluster configuration

Help
1

I have a question about setting the maximum memory for the nodes.

When I have 2 leaf nodes on the same host, and the total memory of the host 128GB and I decided to use 90% of the available memory on the host, which is 115 GB

Should I set the node maximum memory to 115GB then the engine will divide it evenly on leaf nodes, or set the maximum memory to 75GB which is the half of the host available memory

Knowing that NUMA is configured

2

The quickest way to configure memory limits is likely:optimize · SingleStore Documentation

If you want to do it manually though, each memsqld on a host is unaware of others - if left to configure themselves, they will set maximum_memory to 90% of the physical memory on the host. So, you’ll need to configure maximum_memory on each to 75 GB manually.