dbs-tests-1.0.0

VMware testing 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 2006033-NI-1646911951
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Limit displaying results to tests within:

CPU Massive 2 Tests
Database Test Suite 4 Tests
Server 4 Tests
Server CPU Tests 2 Tests

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Geometric Means Per-Suite/Category
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
BESTEDR-[GH_]-00
June 03 2020
  2 Hours, 21 Minutes
S1-TEST-[SD_]-00
June 03 2020
  2 Hours, 20 Minutes
baseline-sys
June 03 2020
  2 Hours, 14 Minutes
SOTERIA-192-[AF_]-00
June 03 2020
  2 Hours, 14 Minutes
Invert Hiding All Results Option
  2 Hours, 17 Minutes

Only show results where is faster than
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):

BESTEDR-[GH_]-00

Processor: 3 x Intel Xeon D-1528 (6 Cores), Motherboard: Intel 440BX (6.00 BIOS), Chipset: Intel 440BX/ZX/DX, Memory: 1 x 8192 MB DRAM, Disk: 107GB Virtual disk, Graphics: VMware SVGA II, Network: VMware VMXNET3

OS: Ubuntu 18.04, Kernel: 4.15.0-91-generic (x86_64), Compiler: GCC 7.5.0, File-System: ext4, Screen Resolution: 1176x885, System Layer: VMware

Compiler Notes: --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
Disk Notes: CFQ / data=ordered,errors=remount-ro,relatime,rw
Processor Notes: CPU Microcode: 0x7000019
Security Notes: itlb_multihit: KVM: Vulnerable + l1tf: Mitigation of PTE Inversion + mds: Mitigation of Clear buffers; SMT Host state unknown + meltdown: Mitigation of PTI + 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 Full generic retpoline IBPB: conditional IBRS_FW STIBP: disabled RSB filling + tsx_async_abort: Not affected

S1-TEST-[SD_]-00

baseline-sys

SOTERIA-192-[AF_]-00

Changed Processor to 2 x Intel Xeon D-1528 (6 Cores).

dbs-tests-1.0.0OpenBenchmarking.orgPhoronix Test Suite3 x Intel Xeon D-1528 (6 Cores)2 x Intel Xeon D-1528 (6 Cores)Intel 440BX (6.00 BIOS)Intel 440BX/ZX/DX1 x 8192 MB DRAM107GB Virtual diskVMware SVGA IIVMware VMXNET3Ubuntu 18.044.15.0-91-generic (x86_64)GCC 7.5.0ext41176x885VMwareProcessorsMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen ResolutionSystem LayerDbs-tests-1.0.0 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 - CFQ / data=ordered,errors=remount-ro,relatime,rw - CPU Microcode: 0x7000019- itlb_multihit: KVM: Vulnerable + l1tf: Mitigation of PTE Inversion + mds: Mitigation of Clear buffers; SMT Host state unknown + meltdown: Mitigation of PTI + 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 Full generic retpoline IBPB: conditional IBRS_FW STIBP: disabled RSB filling + tsx_async_abort: Not affected

BESTEDR-[GH_]-00S1-TEST-[SD_]-00baseline-sysSOTERIA-192-[AF_]-00Result OverviewPhoronix Test Suite100%110%119%129%138%SQLite SpeedtestRedisRedisRedisSQLiteRedisRedisMariaDBTimed Time - Size 1,000LPOPSADDGET32SETLPUSH32

dbs-tests-1.0.0sqlite: 32mysqlslap: 32sqlite-speedtest: Timed Time - Size 1,000redis: LPOPredis: SADDredis: LPUSHredis: GETredis: SETBESTEDR-[GH_]-00S1-TEST-[SD_]-00baseline-sysSOTERIA-192-[AF_]-00261.46296182.9531306665.501066547.25815151.881245974.96947773.98257.70397162.8501270391.621064992.63804487.901253252.42929342.77272.282100132.2401460449.421135074.50873122.641371790.131009977.60246.301100164.5451289781.17998254.31807967.881213805.94927520.39OpenBenchmarking.org

SQLite

This is a simple benchmark of SQLite. At present this test profile just measures the time to perform a pre-defined number of insertions on an indexed database. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 32BESTEDR-[GH_]-00S1-TEST-[SD_]-00baseline-sysSOTERIA-192-[AF_]-0060120180240300SE +/- 0.55, N = 3SE +/- 1.57, N = 3SE +/- 0.23, N = 3SE +/- 0.83, N = 3261.46257.70272.28246.301. (CC) gcc options: -O2 -lz -lm -ldl -lpthread
OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 32BESTEDR-[GH_]-00S1-TEST-[SD_]-00baseline-sysSOTERIA-192-[AF_]-0050100150200250Min: 260.71 / Avg: 261.46 / Max: 262.53Min: 255.47 / Avg: 257.7 / Max: 260.73Min: 271.89 / Avg: 272.28 / Max: 272.69Min: 244.73 / Avg: 246.3 / Max: 247.571. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

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: 32BESTEDR-[GH_]-00S1-TEST-[SD_]-00baseline-sysSOTERIA-192-[AF_]-0020406080100SE +/- 0.04, N = 3SE +/- 0.25, N = 3SE +/- 0.03, N = 3SE +/- 0.17, N = 396971001001. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -lz -lm -lpcre -lcrypt -lssl -lcrypto -ldl
OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 32BESTEDR-[GH_]-00S1-TEST-[SD_]-00baseline-sysSOTERIA-192-[AF_]-0020406080100Min: 95.72 / Avg: 95.79 / Max: 95.83Min: 96.27 / Avg: 96.75 / Max: 97.12Min: 100.1 / Avg: 100.17 / Max: 100.21Min: 99.77 / Avg: 100.01 / Max: 100.341. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -lz -lm -lpcre -lcrypt -lssl -lcrypto -ldl

SQLite Speedtest

This is a benchmark of SQLite's speedtest1 benchmark program with an increased problem size of 1,000. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite Speedtest 3.30Timed Time - Size 1,000BESTEDR-[GH_]-00S1-TEST-[SD_]-00baseline-sysSOTERIA-192-[AF_]-004080120160200SE +/- 0.93, N = 3SE +/- 0.10, N = 3SE +/- 0.39, N = 3SE +/- 2.40, N = 3182.95162.85132.24164.551. (CC) gcc options: -O2 -ldl -lz -lpthread
OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite Speedtest 3.30Timed Time - Size 1,000BESTEDR-[GH_]-00S1-TEST-[SD_]-00baseline-sysSOTERIA-192-[AF_]-00306090120150Min: 181.86 / Avg: 182.95 / Max: 184.81Min: 162.67 / Avg: 162.85 / Max: 163.01Min: 131.71 / Avg: 132.24 / Max: 132.99Min: 161.72 / Avg: 164.55 / Max: 169.311. (CC) gcc options: -O2 -ldl -lz -lpthread

Redis

Redis is an open-source data structure server. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 5.0.5Test: LPOPBESTEDR-[GH_]-00S1-TEST-[SD_]-00baseline-sysSOTERIA-192-[AF_]-00300K600K900K1200K1500KSE +/- 5450.71, N = 3SE +/- 19133.79, N = 15SE +/- 19286.11, N = 5SE +/- 2937.80, N = 31306665.501270391.621460449.421289781.171. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 5.0.5Test: LPOPBESTEDR-[GH_]-00S1-TEST-[SD_]-00baseline-sysSOTERIA-192-[AF_]-00300K600K900K1200K1500KMin: 1300390.12 / Avg: 1306665.5 / Max: 1317523Min: 1044932.06 / Avg: 1270391.62 / Max: 1366120.25Min: 1408450.75 / Avg: 1460449.42 / Max: 1506024.12Min: 1285347 / Avg: 1289781.17 / Max: 1295336.751. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 5.0.5Test: SADDBESTEDR-[GH_]-00S1-TEST-[SD_]-00baseline-sysSOTERIA-192-[AF_]-00200K400K600K800K1000KSE +/- 6135.14, N = 3SE +/- 3997.61, N = 3SE +/- 15607.65, N = 3SE +/- 16997.87, N = 31066547.251064992.631135074.50998254.311. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 5.0.5Test: SADDBESTEDR-[GH_]-00S1-TEST-[SD_]-00baseline-sysSOTERIA-192-[AF_]-00200K400K600K800K1000KMin: 1059322 / Avg: 1066547.25 / Max: 1078748.62Min: 1060445.38 / Avg: 1064992.63 / Max: 1072961.38Min: 1107419.75 / Avg: 1135074.5 / Max: 1161440.12Min: 967117.94 / Avg: 998254.31 / Max: 10256411. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 5.0.5Test: LPUSHBESTEDR-[GH_]-00S1-TEST-[SD_]-00baseline-sysSOTERIA-192-[AF_]-00200K400K600K800K1000KSE +/- 11393.89, N = 4SE +/- 12819.38, N = 3SE +/- 2507.68, N = 3SE +/- 9317.63, N = 3815151.88804487.90873122.64807967.881. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 5.0.5Test: LPUSHBESTEDR-[GH_]-00S1-TEST-[SD_]-00baseline-sysSOTERIA-192-[AF_]-00150K300K450K600K750KMin: 782472.62 / Avg: 815151.88 / Max: 835421.88Min: 779423.25 / Avg: 804487.9 / Max: 821692.69Min: 869565.25 / Avg: 873122.64 / Max: 877963.06Min: 794281.19 / Avg: 807967.88 / Max: 825763.881. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 5.0.5Test: GETBESTEDR-[GH_]-00S1-TEST-[SD_]-00baseline-sysSOTERIA-192-[AF_]-00300K600K900K1200K1500KSE +/- 13328.32, N = 7SE +/- 8666.27, N = 3SE +/- 5728.63, N = 3SE +/- 15426.22, N = 41245974.961253252.421371790.131213805.941. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 5.0.5Test: GETBESTEDR-[GH_]-00S1-TEST-[SD_]-00baseline-sysSOTERIA-192-[AF_]-00200K400K600K800K1000KMin: 1186239.62 / Avg: 1245974.96 / Max: 1293661Min: 1239157.38 / Avg: 1253252.42 / Max: 1269035.5Min: 1360544.25 / Avg: 1371790.13 / Max: 1379310.25Min: 1184834.12 / Avg: 1213805.94 / Max: 1254705.121. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 5.0.5Test: SETBESTEDR-[GH_]-00S1-TEST-[SD_]-00baseline-sysSOTERIA-192-[AF_]-00200K400K600K800K1000KSE +/- 15361.47, N = 3SE +/- 11108.77, N = 3SE +/- 10510.77, N = 3SE +/- 8730.85, N = 3947773.98929342.771009977.60927520.391. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3
OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 5.0.5Test: SETBESTEDR-[GH_]-00S1-TEST-[SD_]-00baseline-sysSOTERIA-192-[AF_]-00200K400K600K800K1000KMin: 917431.19 / Avg: 947773.98 / Max: 967117.94Min: 916590.31 / Avg: 929342.77 / Max: 951474.81Min: 998004 / Avg: 1009977.6 / Max: 1030927.81Min: 914913.06 / Avg: 927520.39 / Max: 944287.061. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

8 Results Shown

SQLite
MariaDB
SQLite Speedtest
Redis:
  LPOP
  SADD
  LPUSH
  GET
  SET

BESTEDR-[GH_]-00

Processor: 3 x Intel Xeon D-1528 (6 Cores), Motherboard: Intel 440BX (6.00 BIOS), Chipset: Intel 440BX/ZX/DX, Memory: 1 x 8192 MB DRAM, Disk: 107GB Virtual disk, Graphics: VMware SVGA II, Network: VMware VMXNET3

OS: Ubuntu 18.04, Kernel: 4.15.0-91-generic (x86_64), Compiler: GCC 7.5.0, File-System: ext4, Screen Resolution: 1176x885, System Layer: VMware

Compiler Notes: --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
Disk Notes: CFQ / data=ordered,errors=remount-ro,relatime,rw
Processor Notes: CPU Microcode: 0x7000019
Security Notes: itlb_multihit: KVM: Vulnerable + l1tf: Mitigation of PTE Inversion + mds: Mitigation of Clear buffers; SMT Host state unknown + meltdown: Mitigation of PTI + 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 Full generic retpoline IBPB: conditional IBRS_FW STIBP: disabled RSB filling + tsx_async_abort: Not affected

Testing initiated at 3 June 2020 07:24 by user root.

S1-TEST-[SD_]-00

Compiler Notes: --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
Disk Notes: CFQ / data=ordered,errors=remount-ro,relatime,rw
Processor Notes: CPU Microcode: 0x7000019
Security Notes: itlb_multihit: KVM: Vulnerable + l1tf: Mitigation of PTE Inversion + mds: Mitigation of Clear buffers; SMT Host state unknown + meltdown: Mitigation of PTI + 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 Full generic retpoline IBPB: conditional IBRS_FW STIBP: disabled RSB filling + tsx_async_abort: Not affected

Testing initiated at 3 June 2020 07:03 by user root.

baseline-sys

Compiler Notes: --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
Disk Notes: CFQ / data=ordered,errors=remount-ro,relatime,rw
Processor Notes: CPU Microcode: 0x7000019
Security Notes: itlb_multihit: KVM: Vulnerable + l1tf: Mitigation of PTE Inversion + mds: Mitigation of Clear buffers; SMT Host state unknown + meltdown: Mitigation of PTI + 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 Full generic retpoline IBPB: conditional IBRS_FW STIBP: disabled RSB filling + tsx_async_abort: Not affected

Testing initiated at 3 June 2020 07:03 by user root.

SOTERIA-192-[AF_]-00

Processor: 2 x Intel Xeon D-1528 (6 Cores), Motherboard: Intel 440BX (6.00 BIOS), Chipset: Intel 440BX/ZX/DX, Memory: 1 x 8192 MB DRAM, Disk: 107GB Virtual disk, Graphics: VMware SVGA II, Network: VMware VMXNET3

OS: Ubuntu 18.04, Kernel: 4.15.0-91-generic (x86_64), Compiler: GCC 7.5.0, File-System: ext4, Screen Resolution: 1176x885, System Layer: VMware

Compiler Notes: --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
Disk Notes: CFQ / data=ordered,errors=remount-ro,relatime,rw
Processor Notes: CPU Microcode: 0x7000019
Security Notes: itlb_multihit: KVM: Vulnerable + l1tf: Mitigation of PTE Inversion + mds: Mitigation of Clear buffers; SMT Host state unknown + meltdown: Mitigation of PTI + 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 Full generic retpoline IBPB: conditional IBRS_FW STIBP: disabled RSB filling + tsx_async_abort: Not affected

Testing initiated at 3 June 2020 07:02 by user root.