AVX2 Instruction Set Verification
On this page
SingleStoreDB 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.
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.avx2
in cpuinfo
output but they still support AVX2.check_
that is part of SingleStoreDB.
For example, to locate it, you can do:
cd / ; sudo find . -name check_avx2 -print
You may see output like:
./var/lib/memsql/master-3306-MI7abac029/lib/check_avx2./var/lib/memsql/leaf-3308-MIae506559/lib/check_avx2./var/lib/memsql/leaf-3307-MIddea06c6/lib/check_avx2
The unique serial numbers and port numbers in this output may differ.
/var/lib/memsql/master-3306-MI7abac029/lib/check_avx2
If it produces no output at all and does not produce an error, then the processor definitely supports AVX2.
Last modified: April 26, 2023