# MEMSQL-OPTIMIZE

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_FILE
                        A path to a MemSQL Ops settings.conf file. If not set,
                        we will use the file in the same directory as the
                        MemSQL Ops binary.
  --async               If this option is true, we will exit without waiting
                        for the cluster to be fully optimized.
  --no-numa             If this option is specified, we will not change NUMA
                        settings on any SingleStore nodes.
  --memory-percentage MEMORY_PERCENTAGE
                        The percentage of memory on each machine that we will
                        use for SingleStore.
  --no-prompt           If this option is specified, we will optimize the
                        cluster without prompting for confirmation.

```

***

Modified at: April 25, 2023

Source: [/db/v7.3/reference/memsql-ops-cli-reference/node-and-cluster-management/memsql-optimize/](https://docs.singlestore.com/db/v7.3/reference/memsql-ops-cli-reference/node-and-cluster-management/memsql-optimize/)

(An index of the documentation is available at /llms.txt)