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