Database workstation Bas

KVM VirtualBox testing on CentOS Linux 7 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 1911058-AS-DATABASEW42
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
db_ws_bas
November 05 2019
  2 Hours, 8 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):


Database workstation BasOpenBenchmarking.orgPhoronix Test SuiteIntel Core i9-9900K (8 Cores)Oracle VirtualBox v1.2Intel 440FX 82441FX PMC8192MB34GB VBOX HDDSVGA3D; buildIntel 82801AA AC 97 Audio2 x Intel 82540EMCentOS Linux 73.10.0-1062.4.1.el7.x86_64 (x86_64)GNOME Shell 3.28.3X Server 1.20.4modesetting 1.20.42.1 Mesa 18.3.4GCC 4.8.5 20150623xfs2560x1335KVM VirtualBoxProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLCompilerFile-SystemScreen ResolutionSystem LayerDatabase Workstation Bas PerformanceSystem Logs- --build=x86_64-redhat-linux --disable-libgcj --disable-libunwind-exceptions --enable-__cxa_atexit --enable-bootstrap --enable-checking=release --enable-gnu-indirect-function --enable-gnu-unique-object --enable-initfini-array --enable-languages=c,c++,objc,obj-c++,java,fortran,ada,go,lto --enable-plugin --enable-shared --enable-threads=posix --mandir=/usr/share/man --with-arch_32=x86-64 --with-linker-hash-style=gnu --with-tune=generic - DEADLINE / attr2,inode64,noquota,relatime,rw,seclabel

Database workstation Bassqlite: Timed SQLite Insertionsmysqlslap: 1mysqlslap: 4mysqlslap: 8mysqlslap: 16mysqlslap: 32mysqlslap: 64mysqlslap: 128mysqlslap: 256pgbench: Buffer Test - Normal Load - Read Onlypgbench: Buffer Test - Normal Load - Read Writepgbench: Buffer Test - Single Thread - Read Onlypgbench: Buffer Test - Single Thread - Read Writepgbench: Buffer Test - Heavy Contention - Read Onlypgbench: Buffer Test - Heavy Contention - Read Writedb_ws_bas6.274910362827471939124673539231888672.4410898.3414337.191545.9788765.779844.36OpenBenchmarking.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.1Timed SQLite Insertionsdb_ws_bas246810SE +/- 0.05, N = 36.271. (CC) gcc options: -O2 -lreadline -ltermcap -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: 1db_ws_bas11002200330044005500SE +/- 8.05, N = 349101. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -llzma -lbz2 -laio -lnuma -lz -lm -lcrypt -lsystemd -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 4db_ws_bas8001600240032004000SE +/- 24.57, N = 336281. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -llzma -lbz2 -laio -lnuma -lz -lm -lcrypt -lsystemd -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 8db_ws_bas6001200180024003000SE +/- 4.36, N = 327471. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -llzma -lbz2 -laio -lnuma -lz -lm -lcrypt -lsystemd -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 16db_ws_bas400800120016002000SE +/- 9.07, N = 319391. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -llzma -lbz2 -laio -lnuma -lz -lm -lcrypt -lsystemd -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 32db_ws_bas30060090012001500SE +/- 2.07, N = 312461. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -llzma -lbz2 -laio -lnuma -lz -lm -lcrypt -lsystemd -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 64db_ws_bas160320480640800SE +/- 2.64, N = 37351. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -llzma -lbz2 -laio -lnuma -lz -lm -lcrypt -lsystemd -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 128db_ws_bas90180270360450SE +/- 1.42, N = 33921. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -llzma -lbz2 -laio -lnuma -lz -lm -lcrypt -lsystemd -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 256db_ws_bas70140210280350SE +/- 1.36, N = 33181. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -llzma -lbz2 -laio -lnuma -lz -lm -lcrypt -lsystemd -lssl -lcrypto -ldl

PostgreSQL pgbench

This is a simple benchmark of PostgreSQL using pgbench. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Buffer Test - Test: Normal Load - Mode: Read Onlydb_ws_bas20K40K60K80K100KSE +/- 69.27, N = 388672.441. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Buffer Test - Test: Normal Load - Mode: Read Writedb_ws_bas2K4K6K8K10KSE +/- 23.82, N = 310898.341. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Buffer Test - Test: Single Thread - Mode: Read Onlydb_ws_bas3K6K9K12K15KSE +/- 65.61, N = 314337.191. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Buffer Test - Test: Single Thread - Mode: Read Writedb_ws_bas30060090012001500SE +/- 13.98, N = 111545.971. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Onlydb_ws_bas20K40K60K80K100KSE +/- 100.92, N = 388765.771. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Writedb_ws_bas2K4K6K8K10KSE +/- 49.59, N = 39844.361. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm