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