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 2106162-IB-2106162IB23 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/2106162-IB-2106162IB23 .
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 90 load optane 16g 1:1:1 load over 90 optane 16g 1:1:1 load over 90 dram 512g load over 90 dram 512g retry load over 90 dram 512g retry 2 load over 90 optane 32g 2:2:2 load over 90 optane 32g 2:2:2 retry 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 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 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: 1 mysqlslap: 4 mysqlslap: 8 mysqlslap: 16 mysqlslap: 32 mysqlslap: 64 mysqlslap: 128 mysqlslap: 256 mysqlslap: 512 noload optane 16g 1:1:1 noload dram 512g noload optane 1.5tb 2:2:2 90 load optane 16g 1:1:1 load over 90 optane 16g 1:1:1 load over 90 dram 512g load over 90 dram 512g retry load over 90 dram 512g retry 2 load over 90 optane 32g 2:2:2 load over 90 optane 32g 2:2:2 retry 11953 10136 9148 6789 2927 1288 551 460 459 12097 10170 9065 6782 2924 1296 553 462 459 11771 10205 9148 6550 2874 1267 545 457 456 11719 9679 9147 6452 2924 1263 543 453 453 11908 9805 9010 6467 2882 1260 544 453 451 12146 10239 9037 6805 2938 1284 12000 9904 9012 6727 2956 1290 549 458 458 12005 9869 8956 6775 2927 1269 543 OpenBenchmarking.org
MariaDB Clients: 1 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.5.2 Clients: 1 noload optane 16g 1:1:1 noload dram 512g noload optane 1.5tb 2:2:2 90 load optane 16g 1:1:1 load over 90 optane 16g 1:1:1 load over 90 dram 512g load over 90 dram 512g retry 2 load over 90 optane 32g 2:2:2 3K 6K 9K 12K 15K SE +/- 47.81, N = 3 SE +/- 48.98, N = 3 SE +/- 94.30, N = 9 SE +/- 45.60, N = 3 SE +/- 140.10, N = 3 SE +/- 48.98, N = 3 SE +/- 47.81, N = 3 SE +/- 112.73, N = 6 11953 12097 11771 11719 11908 12146 12000 12005 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 16g 1:1:1 noload dram 512g noload optane 1.5tb 2:2:2 90 load optane 16g 1:1:1 load over 90 optane 16g 1:1:1 load over 90 dram 512g load over 90 dram 512g retry 2 load over 90 optane 32g 2:2:2 2K 4K 6K 8K 10K SE +/- 68.03, N = 3 SE +/- 34.36, N = 3 SE +/- 60.12, N = 3 SE +/- 82.23, N = 3 SE +/- 55.50, N = 3 SE +/- 35.07, N = 3 SE +/- 113.25, N = 3 SE +/- 32.36, N = 3 10136 10170 10205 9679 9805 10239 9904 9869 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 16g 1:1:1 noload dram 512g noload optane 1.5tb 2:2:2 90 load optane 16g 1:1:1 load over 90 optane 16g 1:1:1 load over 90 dram 512g load over 90 dram 512g retry 2 load over 90 optane 32g 2:2:2 2K 4K 6K 8K 10K SE +/- 73.47, N = 3 SE +/- 72.15, N = 3 SE +/- 73.47, N = 3 SE +/- 56.12, N = 3 SE +/- 81.91, N = 3 SE +/- 72.34, N = 3 SE +/- 125.49, N = 3 SE +/- 71.04, N = 3 9148 9065 9148 9147 9010 9037 9012 8956 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 90 load optane 16g 1:1:1 load over 90 optane 16g 1:1:1 load over 90 dram 512g load over 90 dram 512g retry 2 load over 90 optane 32g 2:2:2 1500 3000 4500 6000 7500 SE +/- 66.73, N = 3 SE +/- 77.88, N = 4 SE +/- 28.48, N = 3 SE +/- 48.07, N = 3 SE +/- 78.45, N = 3 SE +/- 97.30, N = 3 SE +/- 30.03, N = 3 SE +/- 93.36, N = 3 6789 6782 6550 6452 6467 6805 6727 6775 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 90 load optane 16g 1:1:1 load over 90 optane 16g 1:1:1 load over 90 dram 512g load over 90 dram 512g retry 2 load over 90 optane 32g 2:2:2 600 1200 1800 2400 3000 SE +/- 14.21, N = 3 SE +/- 13.01, N = 3 SE +/- 12.66, N = 3 SE +/- 9.87, N = 3 SE +/- 4.79, N = 3 SE +/- 5.77, N = 3 SE +/- 5.84, N = 3 SE +/- 14.21, N = 3 2927 2924 2874 2924 2882 2938 2956 2927 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 optane 16g 1:1:1 noload dram 512g noload optane 1.5tb 2:2:2 90 load optane 16g 1:1:1 load over 90 optane 16g 1:1:1 load over 90 dram 512g load over 90 dram 512g retry 2 load over 90 optane 32g 2:2:2 300 600 900 1200 1500 SE +/- 1.10, N = 3 SE +/- 1.48, N = 3 SE +/- 0.93, N = 3 SE +/- 0.92, N = 3 SE +/- 4.14, N = 3 SE +/- 3.97, N = 3 SE +/- 1.47, N = 3 SE +/- 1.94, N = 3 1288 1296 1267 1263 1260 1284 1290 1269 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 optane 16g 1:1:1 noload dram 512g noload optane 1.5tb 2:2:2 90 load optane 16g 1:1:1 load over 90 optane 16g 1:1:1 load over 90 dram 512g retry 2 load over 90 optane 32g 2:2:2 120 240 360 480 600 SE +/- 0.97, N = 3 SE +/- 1.12, N = 3 SE +/- 1.07, N = 3 SE +/- 0.51, N = 3 SE +/- 1.14, N = 3 SE +/- 0.35, N = 3 SE +/- 0.95, N = 3 551 553 545 543 544 549 543 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 optane 16g 1:1:1 noload dram 512g noload optane 1.5tb 2:2:2 90 load optane 16g 1:1:1 load over 90 optane 16g 1:1:1 load over 90 dram 512g retry 2 100 200 300 400 500 SE +/- 0.73, N = 3 SE +/- 0.86, N = 3 SE +/- 0.07, N = 3 SE +/- 0.79, N = 3 SE +/- 0.61, N = 3 SE +/- 1.01, N = 3 460 462 457 453 453 458 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 optane 16g 1:1:1 noload dram 512g noload optane 1.5tb 2:2:2 90 load optane 16g 1:1:1 load over 90 optane 16g 1:1:1 load over 90 dram 512g retry 2 100 200 300 400 500 SE +/- 0.74, N = 3 SE +/- 1.28, N = 3 SE +/- 0.69, N = 3 SE +/- 0.85, N = 3 SE +/- 1.30, N = 3 SE +/- 0.67, N = 3 459 459 456 453 451 458 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl
Phoronix Test Suite v10.8.4