mysqlComp

Intel Xeon Silver 4210R testing with a Wistron SV7220G3 (TPC_P18C BIOS) and ASPEED on Ubuntu 20.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 2012166-FI-MYSQLCOMP83
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
mysqlComp
December 16 2020
  1 Hour, 46 Minutes
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):


mysqlCompOpenBenchmarking.orgPhoronix Test SuiteIntel Xeon Silver 4210R @ 3.20GHz (10 Cores / 20 Threads)Wistron SV7220G3 (TPC_P18C BIOS)Intel Sky Lake-E DMI3 Registers94GB2 x 960GB SAMSUNG MZ1LB960HAJQ-00007 + 2 x 240GB SAMSUNG MZ7LH240ASPEEDIntel I210 + 2 x Mellanox MT27710Ubuntu 20.045.4.0-58-generic (x86_64)GCC 9.3.0ext41024x768ProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen ResolutionMysqlComp BenchmarksSystem Logs- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --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++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-9-HskZEa/gcc-9-9.3.0/debian/tmp-nvptx/usr,hsa --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=auto --with-tune=generic --without-cuda-driver -v - Scaling Governor: intel_pstate powersave - CPU Microcode: 0x5003003- 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

mysqlCompmysqlslap: 1mysqlslap: 4mysqlslap: 8mysqlslap: 16mysqlslap: 32mysqlslap: 64mysqlslap: 128mysqlslap: 256mysqlslap: 512mysqlComp918672996424526331151160409337333OpenBenchmarking.org

MariaDB

This is a MariaDB MySQL database server benchmark making use of mysqlslap. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 1mysqlComp2K4K6K8K10KSE +/- 12.14, N = 791861. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 4mysqlComp16003200480064008000SE +/- 0.00, N = 372991. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 8mysqlComp14002800420056007000SE +/- 13.79, N = 364241. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 16mysqlComp11002200330044005500SE +/- 15.99, N = 352631. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 32mysqlComp7001400210028003500SE +/- 14.88, N = 331151. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 64mysqlComp2004006008001000SE +/- 11.26, N = 311601. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 128mysqlComp90180270360450SE +/- 2.42, N = 34091. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 256mysqlComp70140210280350SE +/- 2.07, N = 33371. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 512mysqlComp70140210280350SE +/- 0.68, N = 33331. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -laio -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -ldl

9 Results Shown

MariaDB:
  1
  4
  8
  16
  32
  64
  128
  256
  512