MEMSQL-OPTIMIZE
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
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