AVX2 Instruction Set Verification

SingleStore can make use of AVX2 instructions on Intel and Intel-compatible processors, both for improved performance for columnstore query processing, and to enable use of certain vector functions. You can check your system to see if it is supported if you are not sure.

Verifying AVX2 Support

If you want to verify if your system supports the AVX2 instruction set, check your processor specifications from the manufacturer or run cat /proc/cpuinfo | grep avx2 to see if avx2 (in lower case) is listed. Some VM installations, including cloud installations, may not show avx2 in cpuinfo output but they still support AVX2. If you want to definitively check if a node on your system supports AVX2, after installing SingleStore on that node, you can run a utility called check_avx2 that is part of SingleStore.

For example, to locate it, you can do:

cd / ; sudo find . -name check_avx2 -print

You may see output like:


The unique serial numbers and port numbers in this output may differ. Run any one of these check_avx2 executables (they are all the same). For example:


If it produces no output at all and does not produce an error, then the processor definitely supports AVX2. If it produces an error or otherwise fails, AVX2 is not supported.

Last modified: April 26, 2023

Was this article helpful?