# AVX2 Instruction Set Verification

SingleStore can take advantage of the [AVX2 instruction set](https://en.wikipedia.org/wiki/Advanced_Vector_Extensions) on Intel and Intel-compatible processors to improve the performance of [columnstore query processing](https://docs.singlestore.com/db/v9.1/create-a-database/columnstore.md) and enable the use of certain [vector functions](https://docs.singlestore.com/db/v9.1/reference/sql-reference/vector-functions/using-vector-functions.md).

## Verify AVX2 Support

A host’s support for the AVX2 instruction set can be verified in a number of ways:

* Checking the host's processor specifications from the manufacturer.
* Running either of the following on the command line and confirming that `avx2` is listed.
  ```shell
  lscpu | grep avx2

  ```
  ```shell
  cat /proc/cpuinfo | grep avx2
  ```
* Deploying a new SingleStore cluster, where Toolbox [automatically checks](https://docs.singlestore.com/db/v9.1/reference/configuration-reference/cluster-configuration/system-requirements-and-recommendations.md) for `avx2` support.
* Running `check_avx2` from the `singlestoredb-server-<version>-<hash>/lib` directory on each host in an existing SingleStore cluster.

  AVX2 is supported if `check_avx2` does not produce any output, does not produce an error, or does not fail.

  * Typical package-based deployment location

    * `/opt/singlestoredb-server-<version>-<hash>/lib/check_avx2`
  * Typical tarball-based deployment locations

    * `/opt/singlestore/singlestoredb-server-<version>-<hash>/lib/check_avx2`
    * `/home/memsql/memsql/singlestoredb-server-<version>-<hash>/lib/check_avx2`
  * You may also find the location of the `singlestoredb-server-<version>-<hash>` directory by viewing the process status of `memsqld`.
    ```shell
    ps -ef | grep memsqld

    ```
    ```output

    /opt/singlestore/singlestoredb-server-<version>-<hash>/memsqld
    ```

***

Modified at: April 12, 2024

Source: [/db/v9.1/reference/configuration-reference/cluster-configuration/avx-2-instruction-set-verification/](https://docs.singlestore.com/db/v9.1/reference/configuration-reference/cluster-configuration/avx-2-instruction-set-verification/)

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