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-2106156IB90.

mysqlslap vsProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen Resolutionnoload optane 16g 1:1:1noload dram 512gnoload optane 1.5tb 2:2:290 load optane 16g 1:1:1load over 90 optane 16g 1:1:1load over 90 dram 512gload over 90 dram 512g retryload over 90 dram 512g retry 22 x Intel Xeon Gold 5220R (48 Cores / 96 Threads)HPE ProLiant DL360 Gen10 (U32 BIOS)Intel Sky Lake-E DMI3 Registers129408 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/s3201GB MO003200KWVUVMatrox MGA G200eH32 x Intel 10G X550TUbuntu 18.044.15.0-140-generic (x86_64)GCC 7.5.0ext41024x76816 x 32 GB DDR4-2666MT/s HPE32 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/s129408 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/s16 x 32 GB DDR4-2666MT/s HPEOpenBenchmarking.orgKernel Details- nvme_core.multipath=0 - Transparent Huge Pages: madviseCompiler 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 -vProcessor Details- CPU Microcode: 0x5003003Security 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 vsmysqlslap: 1mysqlslap: 4mysqlslap: 8mysqlslap: 16mysqlslap: 32mysqlslap: 64mysqlslap: 128mysqlslap: 256mysqlslap: 512noload optane 16g 1:1:1noload dram 512gnoload optane 1.5tb 2:2:290 load optane 16g 1:1:1load over 90 optane 16g 1:1:1load over 90 dram 512gload over 90 dram 512g retryload over 90 dram 512g retry 211953101369148678929271288551460459120971017090656782292412965534624591177110205914865502874126754545745611719967991476452292412635434534531190898059010646728821260544453451121461023990376805293812841200099049012672729561290549458458OpenBenchmarking.org

MariaDB

Clients: 1

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 1noload optane 16g 1:1:1noload dram 512gnoload optane 1.5tb 2:2:290 load optane 16g 1:1:1load over 90 optane 16g 1:1:1load over 90 dram 512gload over 90 dram 512g retry 23K6K9K12K15KSE +/- 47.81, N = 3SE +/- 48.98, N = 3SE +/- 94.30, N = 9SE +/- 45.60, N = 3SE +/- 140.10, N = 3SE +/- 48.98, N = 3SE +/- 47.81, N = 3119531209711771117191190812146120001. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 4

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 4noload optane 16g 1:1:1noload dram 512gnoload optane 1.5tb 2:2:290 load optane 16g 1:1:1load over 90 optane 16g 1:1:1load over 90 dram 512gload over 90 dram 512g retry 22K4K6K8K10KSE +/- 68.03, N = 3SE +/- 34.36, N = 3SE +/- 60.12, N = 3SE +/- 82.23, N = 3SE +/- 55.50, N = 3SE +/- 35.07, N = 3SE +/- 113.25, N = 3101361017010205967998051023999041. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 8

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 8noload optane 16g 1:1:1noload dram 512gnoload optane 1.5tb 2:2:290 load optane 16g 1:1:1load over 90 optane 16g 1:1:1load over 90 dram 512gload over 90 dram 512g retry 22K4K6K8K10KSE +/- 73.47, N = 3SE +/- 72.15, N = 3SE +/- 73.47, N = 3SE +/- 56.12, N = 3SE +/- 81.91, N = 3SE +/- 72.34, N = 3SE +/- 125.49, N = 391489065914891479010903790121. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 16

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 16noload optane 16g 1:1:1noload dram 512gnoload optane 1.5tb 2:2:290 load optane 16g 1:1:1load over 90 optane 16g 1:1:1load over 90 dram 512gload over 90 dram 512g retry 215003000450060007500SE +/- 66.73, N = 3SE +/- 77.88, N = 4SE +/- 28.48, N = 3SE +/- 48.07, N = 3SE +/- 78.45, N = 3SE +/- 97.30, N = 3SE +/- 30.03, N = 367896782655064526467680567271. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 32

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 32noload optane 16g 1:1:1noload dram 512gnoload optane 1.5tb 2:2:290 load optane 16g 1:1:1load over 90 optane 16g 1:1:1load over 90 dram 512gload over 90 dram 512g retry 26001200180024003000SE +/- 14.21, N = 3SE +/- 13.01, N = 3SE +/- 12.66, N = 3SE +/- 9.87, N = 3SE +/- 4.79, N = 3SE +/- 5.77, N = 3SE +/- 5.84, N = 329272924287429242882293829561. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 64

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 64noload optane 16g 1:1:1noload dram 512gnoload optane 1.5tb 2:2:290 load optane 16g 1:1:1load over 90 optane 16g 1:1:1load over 90 dram 512gload over 90 dram 512g retry 230060090012001500SE +/- 1.10, N = 3SE +/- 1.48, N = 3SE +/- 0.93, N = 3SE +/- 0.92, N = 3SE +/- 4.14, N = 3SE +/- 3.97, N = 3SE +/- 1.47, N = 312881296126712631260128412901. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 128noload optane 16g 1:1:1noload dram 512gnoload optane 1.5tb 2:2:290 load optane 16g 1:1:1load over 90 optane 16g 1:1:1load over 90 dram 512g retry 2120240360480600SE +/- 0.97, N = 3SE +/- 1.12, N = 3SE +/- 1.07, N = 3SE +/- 0.51, N = 3SE +/- 1.14, N = 3SE +/- 0.35, N = 35515535455435445491. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 256

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 256noload optane 16g 1:1:1noload dram 512gnoload optane 1.5tb 2:2:290 load optane 16g 1:1:1load over 90 optane 16g 1:1:1load over 90 dram 512g retry 2100200300400500SE +/- 0.73, N = 3SE +/- 0.86, N = 3SE +/- 0.07, N = 3SE +/- 0.79, N = 3SE +/- 0.61, N = 3SE +/- 1.01, N = 34604624574534534581. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 512

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 512noload optane 16g 1:1:1noload dram 512gnoload optane 1.5tb 2:2:290 load optane 16g 1:1:1load over 90 optane 16g 1:1:1load over 90 dram 512g retry 2100200300400500SE +/- 0.74, N = 3SE +/- 1.28, N = 3SE +/- 0.69, N = 3SE +/- 0.85, N = 3SE +/- 1.30, N = 3SE +/- 0.67, N = 34594594564534514581. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl

Phoronix Test Suite v10.8.4