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 db_ws_bas Processor: Intel Core i9-9900K (8 Cores), Motherboard: Oracle VirtualBox v1.2, Chipset: Intel 440FX 82441FX PMC, Memory: 8192MB, Disk: 34GB VBOX HDD, Graphics: SVGA3D; build: RELEASE; LLVM;, Audio: Intel 82801AA AC 97 Audio, Network: 2 x Intel 82540EM
OS: CentOS Linux 7, Kernel: 3.10.0-1062.4.1.el7.x86_64 (x86_64), Desktop: GNOME Shell 3.28.3, Display Server: X Server 1.20.4, Display Driver: modesetting 1.20.4, OpenGL: 2.1 Mesa 18.3.4, Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 2560x1335, System Layer: KVM VirtualBox
Compiler Notes: --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=genericDisk Notes: DEADLINE / attr2,inode64,noquota,relatime,rw,seclabel
Database workstation Bas OpenBenchmarking.org Phoronix Test Suite Intel Core i9-9900K (8 Cores) Oracle VirtualBox v1.2 Intel 440FX 82441FX PMC 8192MB 34GB VBOX HDD SVGA3D; build Intel 82801AA AC 97 Audio 2 x Intel 82540EM CentOS Linux 7 3.10.0-1062.4.1.el7.x86_64 (x86_64) GNOME Shell 3.28.3 X Server 1.20.4 modesetting 1.20.4 2.1 Mesa 18.3.4 GCC 4.8.5 20150623 xfs 2560x1335 KVM VirtualBox Processor Motherboard Chipset Memory Disk Graphics Audio Network OS Kernel Desktop Display Server Display Driver OpenGL Compiler File-System Screen Resolution System Layer Database Workstation Bas Performance System 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 Bas sqlite: Timed SQLite Insertions mysqlslap: 1 mysqlslap: 4 mysqlslap: 8 mysqlslap: 16 mysqlslap: 32 mysqlslap: 64 mysqlslap: 128 mysqlslap: 256 pgbench: Buffer Test - Normal Load - Read Only pgbench: Buffer Test - Normal Load - Read Write pgbench: Buffer Test - Single Thread - Read Only pgbench: Buffer Test - Single Thread - Read Write pgbench: Buffer Test - Heavy Contention - Read Only pgbench: Buffer Test - Heavy Contention - Read Write db_ws_bas 6.27 4910 3628 2747 1939 1246 735 392 318 88672.44 10898.34 14337.19 1545.97 88765.77 9844.36 OpenBenchmarking.org
OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.3.8 Clients: 4 db_ws_bas 800 1600 2400 3200 4000 SE +/- 24.57, N = 3 3628 1. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -llzma -lbz2 -laio -lnuma -lz -lm -lcrypt -lsystemd -lssl -lcrypto -ldl
OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.3.8 Clients: 8 db_ws_bas 600 1200 1800 2400 3000 SE +/- 4.36, N = 3 2747 1. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -llzma -lbz2 -laio -lnuma -lz -lm -lcrypt -lsystemd -lssl -lcrypto -ldl
OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.3.8 Clients: 16 db_ws_bas 400 800 1200 1600 2000 SE +/- 9.07, N = 3 1939 1. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -llzma -lbz2 -laio -lnuma -lz -lm -lcrypt -lsystemd -lssl -lcrypto -ldl
OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.3.8 Clients: 32 db_ws_bas 300 600 900 1200 1500 SE +/- 2.07, N = 3 1246 1. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -llzma -lbz2 -laio -lnuma -lz -lm -lcrypt -lsystemd -lssl -lcrypto -ldl
OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.3.8 Clients: 64 db_ws_bas 160 320 480 640 800 SE +/- 2.64, N = 3 735 1. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -llzma -lbz2 -laio -lnuma -lz -lm -lcrypt -lsystemd -lssl -lcrypto -ldl
OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.3.8 Clients: 128 db_ws_bas 90 180 270 360 450 SE +/- 1.42, N = 3 392 1. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -llzma -lbz2 -laio -lnuma -lz -lm -lcrypt -lsystemd -lssl -lcrypto -ldl
OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.3.8 Clients: 256 db_ws_bas 70 140 210 280 350 SE +/- 1.36, N = 3 318 1. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -llzma -lbz2 -laio -lnuma -lz -lm -lcrypt -lsystemd -lssl -lcrypto -ldl
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 12.0 Scaling: Buffer Test - Test: Normal Load - Mode: Read Write db_ws_bas 2K 4K 6K 8K 10K SE +/- 23.82, N = 3 10898.34 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 12.0 Scaling: Buffer Test - Test: Single Thread - Mode: Read Only db_ws_bas 3K 6K 9K 12K 15K SE +/- 65.61, N = 3 14337.19 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 12.0 Scaling: Buffer Test - Test: Single Thread - Mode: Read Write db_ws_bas 300 600 900 1200 1500 SE +/- 13.98, N = 11 1545.97 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 12.0 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only db_ws_bas 20K 40K 60K 80K 100K SE +/- 100.92, N = 3 88765.77 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
OpenBenchmarking.org TPS, More Is Better PostgreSQL pgbench 12.0 Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write db_ws_bas 2K 4K 6K 8K 10K SE +/- 49.59, N = 3 9844.36 1. (CC) gcc options: -std=gnu99 -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm
db_ws_bas Processor: Intel Core i9-9900K (8 Cores), Motherboard: Oracle VirtualBox v1.2, Chipset: Intel 440FX 82441FX PMC, Memory: 8192MB, Disk: 34GB VBOX HDD, Graphics: SVGA3D; build: RELEASE; LLVM;, Audio: Intel 82801AA AC 97 Audio, Network: 2 x Intel 82540EM
OS: CentOS Linux 7, Kernel: 3.10.0-1062.4.1.el7.x86_64 (x86_64), Desktop: GNOME Shell 3.28.3, Display Server: X Server 1.20.4, Display Driver: modesetting 1.20.4, OpenGL: 2.1 Mesa 18.3.4, Compiler: GCC 4.8.5 20150623, File-System: xfs, Screen Resolution: 2560x1335, System Layer: KVM VirtualBox
Compiler Notes: --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=genericDisk Notes: DEADLINE / attr2,inode64,noquota,relatime,rw,seclabel
Testing initiated at 5 November 2019 14:44 by user bkeur.