db_test

Test performance of db at pve

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2003195-VE-DBTEST94131
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
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
intitialTest1
March 18 2020
  6 Hours, 47 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):


db_testOpenBenchmarking.orgPhoronix Test SuiteCommon KVM (2 Cores)QEMU Standard PC (i440FX + PIIX 1996) (rel-1.12.1-0-ga5cab58e9a3f-prebuilt.qemu.org BIOS)Intel 440FX 82441FX PMC2048MB32GBRealtek RTL-8100/8101L/8139Ubuntu 18.044.15.0-91-generic (x86_64)GCC 7.5.0ext4KVMProcessorMotherboardChipsetMemoryDiskNetworkOSKernelCompilerFile-SystemSystem LayerDb_test BenchmarksSystem Logs- --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 - CPU Microcode: 0x1- itlb_multihit: KVM: Vulnerable + l1tf: Mitigation of PTE Inversion + mds: Vulnerable: Clear buffers attempted no microcode; SMT Host state unknown + meltdown: Mitigation of PTI + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Full generic retpoline STIBP: disabled RSB filling + tsx_async_abort: Not affected

db_testmysqlslap: 1mysqlslap: 4mysqlslap: 8mysqlslap: 16mysqlslap: 32mysqlslap: 64mysqlslap: 128mysqlslap: 256intitialTest1157911519065793611868569OpenBenchmarking.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.3.8Clients: 1intitialTest130060090012001500SE +/- 11.60, N = 31579

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 4intitialTest12004006008001000SE +/- 14.43, N = 71151

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 8intitialTest12004006008001000SE +/- 2.24, N = 3906

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 16intitialTest1130260390520650SE +/- 2.52, N = 3579

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 32intitialTest180160240320400SE +/- 3.36, N = 3361

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 64intitialTest14080120160200SE +/- 0.64, N = 3186

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 128intitialTest120406080100SE +/- 0.74, N = 385

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 256intitialTest11530456075SE +/- 0.43, N = 369

8 Results Shown

MariaDB:
  1
  4
  8
  16
  32
  64
  128
  256