raid60testscsi_sqlite

Intel Xeon E5-2609 v3 testing with a HP ProLiant ML350 Gen9 (P92 BIOS) and Matrox MGA G200EH 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 2008241-NE-RAID60TES44
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
raid60testscsi_sqlite
August 24 2020
  4 Hours, 14 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):

raid60testscsi_sqlite

Processor: Intel Xeon E5-2609 v3 @ 1.90GHz (6 Cores), Motherboard: HP ProLiant ML350 Gen9 (P92 BIOS), Chipset: Intel Xeon E7 v3/Xeon, Memory: 2 x 8192 MB DDR4-2133MT/s 752368-081, Disk: 21990GB LOGICAL VOLUME + 5498GB LOGICAL VOLUME + Transcend 32GB, Graphics: Matrox MGA G200EH, Network: 4 x Broadcom NetXtreme BCM5719 PCIe

OS: Ubuntu 20.04, Kernel: 5.4.0-42-generic (x86_64), Compiler: GCC 9.3.0, File-System: fuseblk, Screen Resolution: 1024x768

Compiler Notes: --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,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
Disk Notes: MQ-DEADLINE / relatime,rw
Processor Notes: Scaling Governor: intel_pstate powersave - CPU Microcode: 0x43
Security Notes: itlb_multihit: KVM: Mitigation of Split huge pages + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT disabled + mds: Mitigation of Clear buffers; SMT disabled + 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 + srbds: Not affected + tsx_async_abort: Not affected

raid60testscsi_sqliteOpenBenchmarking.orgPhoronix Test SuiteIntel Xeon E5-2609 v3 @ 1.90GHz (6 Cores)HP ProLiant ML350 Gen9 (P92 BIOS)Intel Xeon E7 v3/Xeon2 x 8192 MB DDR4-2133MT/s 752368-08121990GB LOGICAL VOLUME + 5498GB LOGICAL VOLUME + Transcend 32GBMatrox MGA G200EH4 x Broadcom NetXtreme BCM5719 PCIeUbuntu 20.045.4.0-42-generic (x86_64)GCC 9.3.0fuseblk1024x768ProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelCompilerFile-SystemScreen ResolutionRaid60testscsi_sqlite 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,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 - MQ-DEADLINE / relatime,rw- Scaling Governor: intel_pstate powersave - CPU Microcode: 0x43- itlb_multihit: KVM: Mitigation of Split huge pages + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT disabled + mds: Mitigation of Clear buffers; SMT disabled + 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 + srbds: Not affected + tsx_async_abort: Not affected

raid60testscsi_sqlitesqlite: 1sqlite: 8sqlite: 32sqlite: 64sqlite: 128raid60testscsi_sqlite73.870150.222667.4341381.4802790.053OpenBenchmarking.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: 1raid60testscsi_sqlite1632486480SE +/- 0.18, N = 373.871. (CC) gcc options: -O2 -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 8raid60testscsi_sqlite306090120150SE +/- 0.39, N = 3150.221. (CC) gcc options: -O2 -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 32raid60testscsi_sqlite140280420560700SE +/- 1.03, N = 3667.431. (CC) gcc options: -O2 -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 64raid60testscsi_sqlite30060090012001500SE +/- 0.68, N = 31381.481. (CC) gcc options: -O2 -lm -ldl -lpthread

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 128raid60testscsi_sqlite6001200180024003000SE +/- 2.37, N = 32790.051. (CC) gcc options: -O2 -lm -ldl -lpthread

raid60testscsi_sqlite

Processor: Intel Xeon E5-2609 v3 @ 1.90GHz (6 Cores), Motherboard: HP ProLiant ML350 Gen9 (P92 BIOS), Chipset: Intel Xeon E7 v3/Xeon, Memory: 2 x 8192 MB DDR4-2133MT/s 752368-081, Disk: 21990GB LOGICAL VOLUME + 5498GB LOGICAL VOLUME + Transcend 32GB, Graphics: Matrox MGA G200EH, Network: 4 x Broadcom NetXtreme BCM5719 PCIe

OS: Ubuntu 20.04, Kernel: 5.4.0-42-generic (x86_64), Compiler: GCC 9.3.0, File-System: fuseblk, Screen Resolution: 1024x768

Compiler Notes: --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,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
Disk Notes: MQ-DEADLINE / relatime,rw
Processor Notes: Scaling Governor: intel_pstate powersave - CPU Microcode: 0x43
Security Notes: itlb_multihit: KVM: Mitigation of Split huge pages + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT disabled + mds: Mitigation of Clear buffers; SMT disabled + 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 + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 24 August 2020 17:03 by user root.