2 x Intel Xeon Gold 5220R testing with a HPE ProLiant DL360 Gen10 (U32 BIOS) and Matrox MGA G200eH3 on Ubuntu 18.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 2106153-IB-2106154IB44 mysqlslap vs - Phoronix Test Suite mysqlslap vs 2 x Intel Xeon Gold 5220R testing with a HPE ProLiant DL360 Gen10 (U32 BIOS) and Matrox MGA G200eH3 on Ubuntu 18.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2106153-IB-2106154IB44&sro&grs .
mysqlslap vs Processor Motherboard Chipset Memory Disk Graphics Network OS Kernel Compiler File-System Screen Resolution noload optane 16g 1:1:1 noload dram 512g noload optane 1.5tb 2:2:2 2 x Intel Xeon Gold 5220R (48 Cores / 96 Threads) HPE ProLiant DL360 Gen10 (U32 BIOS) Intel Sky Lake-E DMI3 Registers 129408 MB + 16384 MB + 16384 MB + 16384 MB + 16384 MB + 129408 MB + 129408 MB + 16384 MB + 16384 MB + 16384 MB + 16384 MB + 129408 MB DDR4-2666MT/s 3201GB MO003200KWVUV Matrox MGA G200eH3 2 x Intel 10G X550T Ubuntu 18.04 4.15.0-140-generic (x86_64) GCC 7.5.0 ext4 1024x768 16 x 32 GB DDR4-2666MT/s HPE 32 GB + 129408 MB + 32 GB + 129408 MB + 32 GB + 129408 MB + 129408 MB + 32 GB + 129408 MB + 32 GB + 129408 MB + 32 GB + 32 GB + 129408 MB + 32 GB + 129408 MB + 32 GB + 129408 MB + 129408 MB + 32 GB + 129408 MB + 32 GB + 129408 MB + 32 GB DDR4-2666MT/s OpenBenchmarking.org Kernel Details - nvme_core.multipath=0 - Transparent Huge Pages: madvise Compiler Details - --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --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++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none --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 --with-tune=generic --without-cuda-driver -v Processor Details - CPU Microcode: 0x5003003 Security Details - 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
mysqlslap vs mysqlslap: 16 mysqlslap: 1 mysqlslap: 64 mysqlslap: 32 mysqlslap: 128 mysqlslap: 256 mysqlslap: 8 mysqlslap: 4 mysqlslap: 512 noload optane 16g 1:1:1 noload dram 512g noload optane 1.5tb 2:2:2 6789 11953 1288 2927 551 460 9148 10136 459 6782 12097 1296 2924 553 462 9065 10170 459 6550 11771 1267 2874 545 457 9148 10205 456 OpenBenchmarking.org
MariaDB Clients: 16 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 16 noload dram 512g noload optane 1.5tb 2:2:2 noload optane 16g 1:1:1 1500 3000 4500 6000 7500 SE +/- 77.88, N = 4 SE +/- 28.48, N = 3 SE +/- 66.73, N = 3 6782 6550 6789 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl
MariaDB Clients: 1 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 1 noload dram 512g noload optane 1.5tb 2:2:2 noload optane 16g 1:1:1 3K 6K 9K 12K 15K SE +/- 48.98, N = 3 SE +/- 94.30, N = 9 SE +/- 47.81, N = 3 12097 11771 11953 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl
MariaDB Clients: 64 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 64 noload dram 512g noload optane 1.5tb 2:2:2 noload optane 16g 1:1:1 300 600 900 1200 1500 SE +/- 1.48, N = 3 SE +/- 0.93, N = 3 SE +/- 1.10, N = 3 1296 1267 1288 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl
MariaDB Clients: 32 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 32 noload dram 512g noload optane 1.5tb 2:2:2 noload optane 16g 1:1:1 600 1200 1800 2400 3000 SE +/- 13.01, N = 3 SE +/- 12.66, N = 3 SE +/- 14.21, N = 3 2924 2874 2927 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl
MariaDB Clients: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 128 noload dram 512g noload optane 1.5tb 2:2:2 noload optane 16g 1:1:1 120 240 360 480 600 SE +/- 1.12, N = 3 SE +/- 1.07, N = 3 SE +/- 0.97, N = 3 553 545 551 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl
MariaDB Clients: 256 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 256 noload dram 512g noload optane 1.5tb 2:2:2 noload optane 16g 1:1:1 100 200 300 400 500 SE +/- 0.86, N = 3 SE +/- 0.07, N = 3 SE +/- 0.73, N = 3 462 457 460 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl
MariaDB Clients: 8 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 8 noload dram 512g noload optane 1.5tb 2:2:2 noload optane 16g 1:1:1 2K 4K 6K 8K 10K SE +/- 72.15, N = 3 SE +/- 73.47, N = 3 SE +/- 73.47, N = 3 9065 9148 9148 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl
MariaDB Clients: 4 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 4 noload dram 512g noload optane 1.5tb 2:2:2 noload optane 16g 1:1:1 2K 4K 6K 8K 10K SE +/- 34.36, N = 3 SE +/- 60.12, N = 3 SE +/- 68.03, N = 3 10170 10205 10136 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl
MariaDB Clients: 512 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 512 noload dram 512g noload optane 1.5tb 2:2:2 noload optane 16g 1:1:1 100 200 300 400 500 SE +/- 1.28, N = 3 SE +/- 0.69, N = 3 SE +/- 0.74, N = 3 459 456 459 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl
Phoronix Test Suite v10.8.4