On this page
Recommends and optimizes the cluster for maximum performance.
If you have numactl installed, set up NUMA based on the number of cores and leaves
Recommends that you install new leaves if the number of leaves is less than what is recommended by the NUMA configuration
Ensure that the total amount of memory allocated for the leaves is less than the total memory of the machine
Set the default number of partitions per leaf to the best possible value based on the number of cores available and the total number of leaves
usage: memsql-ops memsql-optimize [--settings-file SETTINGS_FILE] [--async][--no-numa][--memory-percentage MEMORY_PERCENTAGE][--no-prompt]Optimize the cluster for maximum performance.optional arguments:--settings-file SETTINGS_FILEA path to a MemSQL Ops settings.conf file. If not set,we will use the file in the same directory as theMemSQL Ops binary.--async If this option is true, we will exit without waitingfor the cluster to be fully optimized.--no-numa If this option is specified, we will not change NUMAsettings on any SingleStoreDB nodes.--memory-percentage MEMORY_PERCENTAGEThe percentage of memory on each machine that we willuse for SingleStoreDB.--no-prompt If this option is specified, we will optimize thecluster without prompting for confirmation.
Last modified: April 25, 2023