mysqlMgmt Intel Xeon Silver 4210R testing with a Wistron SV7220G3 (TPC_P18C BIOS) and ASPEED on Ubuntu 20.04 via the Phoronix Test Suite.
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2012166-FI-MYSQLMGMT02 mysqlMgmt Processor: Intel Xeon Silver 4210R @ 3.20GHz (10 Cores / 20 Threads), Motherboard: Wistron SV7220G3 (TPC_P18C BIOS), Chipset: Intel Sky Lake-E DMI3 Registers, Memory: 32GB, Disk: 2 x 240GB SAMSUNG MZ7LH240, Graphics: ASPEED, Network: Intel I210 + 2 x Mellanox MT27710
OS: Ubuntu 20.04, Kernel: 5.4.0-58-generic (x86_64), Compiler: GCC 9.3.0, File-System: ext4, Screen Resolution: 1024x768
Compiler Notes: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-HskZEa/gcc-9-9.3.0/debian/tmp-nvptx/usr,hsa --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -vProcessor Notes: Scaling Governor: intel_pstate powersave - CPU Microcode: 0x5003003Security Notes: itlb_multihit: KVM: Mitigation of Split huge pages + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Mitigation of TSX disabled
mysqlMgmt OpenBenchmarking.org Phoronix Test Suite Intel Xeon Silver 4210R @ 3.20GHz (10 Cores / 20 Threads) Wistron SV7220G3 (TPC_P18C BIOS) Intel Sky Lake-E DMI3 Registers 32GB 2 x 240GB SAMSUNG MZ7LH240 ASPEED Intel I210 + 2 x Mellanox MT27710 Ubuntu 20.04 5.4.0-58-generic (x86_64) GCC 9.3.0 ext4 1024x768 Processor Motherboard Chipset Memory Disk Graphics Network OS Kernel Compiler File-System Screen Resolution MysqlMgmt Benchmarks System Logs - --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-HskZEa/gcc-9-9.3.0/debian/tmp-nvptx/usr,hsa --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v - Scaling Governor: intel_pstate powersave - CPU Microcode: 0x5003003 - itlb_multihit: KVM: Mitigation of Split huge pages + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Mitigation of TSX disabled
mysqlMgmt mysqlslap: 512 mysqlslap: 256 mysqlslap: 128 mysqlslap: 64 mysqlslap: 32 mysqlslap: 16 mysqlslap: 8 mysqlslap: 4 mysqlslap: 1 mysqlMgmt 336 334 413 1158 3132 5291 6414 7299 9147 OpenBenchmarking.org
OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 256 mysqlMgmt 70 140 210 280 350 SE +/- 0.81, N = 3 334 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl
OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 128 mysqlMgmt 90 180 270 360 450 SE +/- 1.87, N = 3 413 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl
OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 64 mysqlMgmt 200 400 600 800 1000 SE +/- 7.16, N = 3 1158 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl
OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 32 mysqlMgmt 700 1400 2100 2800 3500 SE +/- 21.57, N = 3 3132 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl
OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 16 mysqlMgmt 1100 2200 3300 4400 5500 SE +/- 16.16, N = 3 5291 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl
OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 8 mysqlMgmt 1400 2800 4200 5600 7000 SE +/- 3.45, N = 12 6414 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl
OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 4 mysqlMgmt 1600 3200 4800 6400 8000 SE +/- 0.00, N = 3 7299 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl
OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 1 mysqlMgmt 2K 4K 6K 8K 10K SE +/- 27.80, N = 3 9147 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl
mysqlMgmt Processor: Intel Xeon Silver 4210R @ 3.20GHz (10 Cores / 20 Threads), Motherboard: Wistron SV7220G3 (TPC_P18C BIOS), Chipset: Intel Sky Lake-E DMI3 Registers, Memory: 32GB, Disk: 2 x 240GB SAMSUNG MZ7LH240, Graphics: ASPEED, Network: Intel I210 + 2 x Mellanox MT27710
OS: Ubuntu 20.04, Kernel: 5.4.0-58-generic (x86_64), Compiler: GCC 9.3.0, File-System: ext4, Screen Resolution: 1024x768
Compiler Notes: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-HskZEa/gcc-9-9.3.0/debian/tmp-nvptx/usr,hsa --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -vProcessor Notes: Scaling Governor: intel_pstate powersave - CPU Microcode: 0x5003003Security Notes: itlb_multihit: KVM: Mitigation of Split huge pages + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Mitigation of TSX disabled
Testing initiated at 16 December 2020 05:10 by user dfogle.