dram-0611-mysql-vs

optane

HTML result view exported from: https://openbenchmarking.org/result/2106121-IB-2106113IB83&sro.

dram-0611-mysql-vsProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen Resolutionunder load 90under load 90 optane 1stunder load 90 optane 2-2-2 1stno loadundr load 98 optane2 x Intel Xeon Gold 5220R (48 Cores / 96 Threads)HPE ProLiant DL360 Gen10 (U32 BIOS)Intel Sky Lake-E DMI3 Registers16 x 32 GB DDR4-2666MT/s HPE3201GB MO003200KWVUVMatrox MGA G200eH32 x Intel 10G X550TUbuntu 18.044.15.0-140-generic (x86_64)GCC 7.5.0ext41024x768129408 MB + 32 GB + 32 GB + 32 GB + 32 GB + 129408 MB + 129408 MB + 32 GB + 32 GB + 32 GB + 32 GB + 129408 MB DDR4-2666MT/s32 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/s16 x 32 GB DDR4-2666MT/s HPE129408 MB + 32 GB + 32 GB + 32 GB + 32 GB + 129408 MB + 129408 MB + 32 GB + 32 GB + 32 GB + 32 GB + 129408 MB DDR4-2666MT/sOpenBenchmarking.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

dram-0611-mysql-vsmysqlslap: 1mysqlslap: 4mysqlslap: 8mysqlslap: 16mysqlslap: 32mysqlslap: 64mysqlslap: 128mysqlslap: 256mysqlslap: 512under load 90under load 90 optane 1stunder load 90 optane 2-2-2 1stno loadundr load 98 optane1176610034895567272885127255045645611719980591366698287412625404494531199698698930707728681271540455450120971023990926819294112945564614611153998699175675228851274542454452OpenBenchmarking.org

MariaDB

Clients: 1

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 1no loadunder load 90under load 90 optane 1stunder load 90 optane 2-2-2 1stundr load 98 optane3K6K9K12K15KSE +/- 48.98, N = 3SE +/- 79.92, N = 3SE +/- 45.60, N = 3SE +/- 129.71, N = 5SE +/- 44.55, N = 312097117661171911996115391. (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: 4no loadunder load 90under load 90 optane 1stunder load 90 optane 2-2-2 1stundr load 98 optane2K4K6K8K10KSE +/- 35.07, N = 3SE +/- 33.67, N = 3SE +/- 55.50, N = 3SE +/- 65.36, N = 3SE +/- 32.36, N = 310239100349805986998691. (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: 8no loadunder load 90under load 90 optane 1stunder load 90 optane 2-2-2 1stundr load 98 optane2K4K6K8K10KSE +/- 83.42, N = 3SE +/- 26.81, N = 3SE +/- 97.43, N = 4SE +/- 80.45, N = 3SE +/- 48.60, N = 3909289559136893091751. (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: 16no loadunder load 90under load 90 optane 1stunder load 90 optane 2-2-2 1stundr load 98 optane15003000450060007500SE +/- 41.14, N = 3SE +/- 40.04, N = 3SE +/- 64.96, N = 3SE +/- 60.56, N = 3SE +/- 46.90, N = 15681967276698707767521. (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: 32no loadunder load 90under load 90 optane 1stunder load 90 optane 2-2-2 1stundr load 98 optane6001200180024003000SE +/- 4.99, N = 3SE +/- 9.98, N = 3SE +/- 8.28, N = 3SE +/- 11.97, N = 3SE +/- 7.35, N = 3294128852874286828851. (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: 64no loadunder load 90under load 90 optane 1stunder load 90 optane 2-2-2 1stundr load 98 optane30060090012001500SE +/- 1.68, N = 3SE +/- 0.54, N = 3SE +/- 1.92, N = 3SE +/- 0.54, N = 3SE +/- 2.81, N = 3129412721262127112741. (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: 128no loadunder load 90under load 90 optane 1stunder load 90 optane 2-2-2 1stundr load 98 optane120240360480600SE +/- 1.09, N = 3SE +/- 0.96, N = 3SE +/- 1.29, N = 3SE +/- 0.29, N = 3SE +/- 0.29, N = 35565505405405421. (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: 256no loadunder load 90under load 90 optane 1stunder load 90 optane 2-2-2 1stundr load 98 optane100200300400500SE +/- 0.21, N = 3SE +/- 0.24, N = 3SE +/- 1.47, N = 3SE +/- 0.60, N = 3SE +/- 1.62, N = 34614564494554541. (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: 512no loadunder load 90under load 90 optane 1stunder load 90 optane 2-2-2 1stundr load 98 optane100200300400500SE +/- 0.74, N = 3SE +/- 1.55, N = 3SE +/- 1.37, N = 3SE +/- 1.19, N = 3SE +/- 0.92, N = 34614564534504521. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lcrypt -lz -lm -lssl -lcrypto -ldl

Phoronix Test Suite v10.8.4