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&grr&sor .
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: 512 mysqlslap: 256 mysqlslap: 128 mysqlslap: 64 mysqlslap: 32 mysqlslap: 16 mysqlslap: 1 mysqlslap: 8 mysqlslap: 4 noload optane 16g 1:1:1 noload dram 512g noload optane 1.5tb 2:2:2 459 460 551 1288 2927 6789 11953 9148 10136 459 462 553 1296 2924 6782 12097 9065 10170 456 457 545 1267 2874 6550 11771 9148 10205 OpenBenchmarking.org
MariaDB Clients: 512 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 512 noload dram 512g noload optane 16g 1:1:1 noload optane 1.5tb 2:2:2 100 200 300 400 500 SE +/- 1.28, N = 3 SE +/- 0.74, N = 3 SE +/- 0.69, N = 3 459 459 456 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 16g 1:1:1 noload optane 1.5tb 2:2:2 100 200 300 400 500 SE +/- 0.86, N = 3 SE +/- 0.73, N = 3 SE +/- 0.07, N = 3 462 460 457 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 16g 1:1:1 noload optane 1.5tb 2:2:2 120 240 360 480 600 SE +/- 1.12, N = 3 SE +/- 0.97, N = 3 SE +/- 1.07, N = 3 553 551 545 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 16g 1:1:1 noload optane 1.5tb 2:2:2 300 600 900 1200 1500 SE +/- 1.48, N = 3 SE +/- 1.10, N = 3 SE +/- 0.93, N = 3 1296 1288 1267 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 optane 16g 1:1:1 noload dram 512g noload optane 1.5tb 2:2:2 600 1200 1800 2400 3000 SE +/- 14.21, N = 3 SE +/- 13.01, N = 3 SE +/- 12.66, N = 3 2927 2924 2874 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl
MariaDB Clients: 16 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 16 noload optane 16g 1:1:1 noload dram 512g noload optane 1.5tb 2:2:2 1500 3000 4500 6000 7500 SE +/- 66.73, N = 3 SE +/- 77.88, N = 4 SE +/- 28.48, N = 3 6789 6782 6550 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 16g 1:1:1 noload optane 1.5tb 2:2:2 3K 6K 9K 12K 15K SE +/- 48.98, N = 3 SE +/- 47.81, N = 3 SE +/- 94.30, N = 9 12097 11953 11771 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 optane 1.5tb 2:2:2 noload optane 16g 1:1:1 noload dram 512g 2K 4K 6K 8K 10K SE +/- 73.47, N = 3 SE +/- 73.47, N = 3 SE +/- 72.15, N = 3 9148 9148 9065 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 optane 1.5tb 2:2:2 noload dram 512g noload optane 16g 1:1:1 2K 4K 6K 8K 10K SE +/- 60.12, N = 3 SE +/- 34.36, N = 3 SE +/- 68.03, N = 3 10205 10170 10136 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl
Phoronix Test Suite v10.8.4