hammerdb zen 4 AMD Ryzen 7 7700X 8-Core testing with a ASRock X670E PG Lightning (1.11 BIOS) and XFX AMD Radeon RX 6400 4GB on Ubuntu 22.10 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2211019-NE-HAMMERDBZ84&gru&rdt .
hammerdb zen 4 Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server OpenGL Vulkan Compiler File-System Screen Resolution a B C AMD Ryzen 7 7700X 8-Core @ 5.57GHz (8 Cores / 16 Threads) ASRock X670E PG Lightning (1.11 BIOS) AMD Device 14d8 32GB 1000GB Western Digital WDS100T1X0E-00AFY0 XFX AMD Radeon RX 6400 4GB (2320/1000MHz) AMD Navi 21/23 ASUS MG28U Realtek RTL8125 2.5GbE Ubuntu 22.10 5.19.0-23-generic (x86_64) GNOME Shell 43.0 X Server + Wayland 4.6 Mesa 22.2.1 (LLVM 15.0.2 DRM 3.47) 1.3.224 GCC 12.2.0 ext4 3840x2160 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Compiler Details - --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-cet --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-defaulted --enable-offload-targets=nvptx-none=/build/gcc-12-U8K4Qv/gcc-12-12.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-12-U8K4Qv/gcc-12-12.2.0/debian/tmp-gcn/usr --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 Processor Details - Scaling Governor: amd-pstate schedutil (Boost: Enabled) - CPU Microcode: 0xa601203 Security Details - itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional IBRS_FW STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected
hammerdb zen 4 hammerdb-mariadb: 8 - 100 hammerdb-mariadb: 8 - 250 hammerdb-mariadb: 16 - 100 hammerdb-mariadb: 16 - 250 hammerdb-mariadb: 32 - 100 hammerdb-mariadb: 32 - 250 hammerdb-mariadb: 64 - 100 hammerdb-mariadb: 64 - 250 hammerdb-postgresql: 8 - 100 hammerdb-postgresql: 8 - 250 hammerdb-postgresql: 16 - 100 hammerdb-postgresql: 16 - 250 hammerdb-postgresql: 32 - 100 hammerdb-postgresql: 32 - 250 hammerdb-postgresql: 64 - 100 hammerdb-postgresql: 64 - 250 hammerdb-mariadb: 8 - 100 hammerdb-mariadb: 8 - 250 hammerdb-mariadb: 16 - 100 hammerdb-mariadb: 16 - 250 hammerdb-mariadb: 32 - 100 hammerdb-mariadb: 32 - 250 hammerdb-mariadb: 64 - 100 hammerdb-mariadb: 64 - 250 hammerdb-postgresql: 8 - 100 hammerdb-postgresql: 8 - 250 hammerdb-postgresql: 16 - 100 hammerdb-postgresql: 16 - 250 hammerdb-postgresql: 32 - 100 hammerdb-postgresql: 32 - 250 hammerdb-postgresql: 64 - 100 hammerdb-postgresql: 64 - 250 a B C 37198 34674 37235 36521 36463 35109 37736 33867 792468 787876 1009575 1021621 1050877 996196 872758 844030 86412 80690 86639 84840 85003 81678 87781 78646 1823531 1811820 2320409 2347144 2416190 2292429 2008916 1943197 32805 33531 34743 35419 36066 33011 37040 32625 530072 603233 942793 714307 804743 818219 342794 364027 76117 77999 80629 82210 83595 76642 86141 75727 1226297 1390404 2165945 1647672 1855573 1885655 797031 842407 33997 33391 34743 35474 35625 31861 36009 31148 353482 404394 384768 339166 303395 211215 143162 107894 78847 77690 80709 82426 82769 74153 83611 72332 827648 942726 894625 790004 705566 490059 332187 251104 OpenBenchmarking.org
HammerDB - MariaDB Virtual Users: 8 - Warehouses: 100 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 8 - Warehouses: 100 a B C 8K 16K 24K 32K 40K 37198 32805 33997 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 8 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 8 - Warehouses: 250 a B C 7K 14K 21K 28K 35K 34674 33531 33391 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 16 - Warehouses: 100 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 16 - Warehouses: 100 a B C 8K 16K 24K 32K 40K 37235 34743 34743 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 16 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 16 - Warehouses: 250 a B C 8K 16K 24K 32K 40K 36521 35419 35474 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 32 - Warehouses: 100 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 32 - Warehouses: 100 a B C 8K 16K 24K 32K 40K 36463 36066 35625 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 32 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 32 - Warehouses: 250 a B C 8K 16K 24K 32K 40K 35109 33011 31861 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 64 - Warehouses: 100 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 64 - Warehouses: 100 a B C 8K 16K 24K 32K 40K 37736 37040 36009 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 64 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 64 - Warehouses: 250 a B C 7K 14K 21K 28K 35K 33867 32625 31148 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - PostgreSQL Virtual Users: 8 - Warehouses: 100 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 8 - Warehouses: 100 a B C 200K 400K 600K 800K 1000K 792468 530072 353482 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 8 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 8 - Warehouses: 250 a B C 200K 400K 600K 800K 1000K 787876 603233 404394 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 16 - Warehouses: 100 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 16 - Warehouses: 100 a B C 200K 400K 600K 800K 1000K 1009575 942793 384768 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 16 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 16 - Warehouses: 250 a B C 200K 400K 600K 800K 1000K 1021621 714307 339166 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 32 - Warehouses: 100 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 32 - Warehouses: 100 a B C 200K 400K 600K 800K 1000K 1050877 804743 303395 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 32 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 32 - Warehouses: 250 a B C 200K 400K 600K 800K 1000K 996196 818219 211215 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 64 - Warehouses: 100 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 64 - Warehouses: 100 a B C 200K 400K 600K 800K 1000K 872758 342794 143162 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 64 - Warehouses: 250 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 64 - Warehouses: 250 a B C 200K 400K 600K 800K 1000K 844030 364027 107894 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - MariaDB Virtual Users: 8 - Warehouses: 100 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 8 - Warehouses: 100 a B C 20K 40K 60K 80K 100K 86412 76117 78847 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 8 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 8 - Warehouses: 250 a B C 20K 40K 60K 80K 100K 80690 77999 77690 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 16 - Warehouses: 100 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 16 - Warehouses: 100 a B C 20K 40K 60K 80K 100K 86639 80629 80709 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 16 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 16 - Warehouses: 250 a B C 20K 40K 60K 80K 100K 84840 82210 82426 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 32 - Warehouses: 100 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 32 - Warehouses: 100 a B C 20K 40K 60K 80K 100K 85003 83595 82769 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 32 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 32 - Warehouses: 250 a B C 20K 40K 60K 80K 100K 81678 76642 74153 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 64 - Warehouses: 100 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 64 - Warehouses: 100 a B C 20K 40K 60K 80K 100K 87781 86141 83611 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 64 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 64 - Warehouses: 250 a B C 20K 40K 60K 80K 100K 78646 75727 72332 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - PostgreSQL Virtual Users: 8 - Warehouses: 100 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 8 - Warehouses: 100 a B C 400K 800K 1200K 1600K 2000K 1823531 1226297 827648 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 8 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 8 - Warehouses: 250 a B C 400K 800K 1200K 1600K 2000K 1811820 1390404 942726 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 16 - Warehouses: 100 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 16 - Warehouses: 100 a B C 500K 1000K 1500K 2000K 2500K 2320409 2165945 894625 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 16 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 16 - Warehouses: 250 a B C 500K 1000K 1500K 2000K 2500K 2347144 1647672 790004 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 32 - Warehouses: 100 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 32 - Warehouses: 100 a B C 500K 1000K 1500K 2000K 2500K 2416190 1855573 705566 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 32 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 32 - Warehouses: 250 a B C 500K 1000K 1500K 2000K 2500K 2292429 1885655 490059 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 64 - Warehouses: 100 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 64 - Warehouses: 100 a B C 400K 800K 1200K 1600K 2000K 2008916 797031 332187 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
HammerDB - PostgreSQL Virtual Users: 64 - Warehouses: 250 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - PostgreSQL 15 Virtual Users: 64 - Warehouses: 250 a B C 400K 800K 1200K 1600K 2000K 1943197 842407 251104 1. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm
Phoronix Test Suite v10.8.5