AMD Ryzen 9 5900HX testing with a ASUS G513QY v1.0 (G513QY.318 BIOS) and ASUS AMD Cezanne 512MB on Ubuntu 22.10 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 2211023-PTS-MARIADB134 mariadb - Phoronix Test Suite mariadb AMD Ryzen 9 5900HX testing with a ASUS G513QY v1.0 (G513QY.318 BIOS) and ASUS AMD Cezanne 512MB on Ubuntu 22.10 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2211023-PTS-MARIADB134&sro .
mariadb 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 9 5900HX @ 4.89GHz (8 Cores / 16 Threads) ASUS G513QY v1.0 (G513QY.318 BIOS) AMD Renoir/Cezanne 16GB 512GB SAMSUNG MZVLQ512HBLU-00B00 ASUS AMD Cezanne 512MB (2500/1000MHz) AMD Navi 21/23 LQ156M1JW25 Realtek RTL8111/8168/8411 + MEDIATEK MT7921 802.11ax PCI 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 1920x1080 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) - Platform Profile: balanced - CPU Microcode: 0xa50000c - ACPI Profile: balanced 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
mariadb hammerdb-mariadb: 8 - 100 hammerdb-mariadb: 8 - 100 hammerdb-mariadb: 8 - 250 hammerdb-mariadb: 8 - 250 hammerdb-mariadb: 8 - 500 hammerdb-mariadb: 8 - 500 hammerdb-mariadb: 16 - 100 hammerdb-mariadb: 16 - 100 hammerdb-mariadb: 16 - 250 hammerdb-mariadb: 16 - 250 hammerdb-mariadb: 16 - 500 hammerdb-mariadb: 16 - 500 hammerdb-mariadb: 32 - 100 hammerdb-mariadb: 32 - 100 hammerdb-mariadb: 32 - 250 hammerdb-mariadb: 32 - 250 hammerdb-mariadb: 32 - 500 hammerdb-mariadb: 32 - 500 hammerdb-mariadb: 64 - 100 hammerdb-mariadb: 64 - 100 hammerdb-mariadb: 64 - 250 hammerdb-mariadb: 64 - 250 hammerdb-mariadb: 64 - 500 hammerdb-mariadb: 64 - 500 a b C 4084 9473 4025 9418 3783 8737 3706 8595 3724 8677 3891 9049 4238 9849 4134 9537 3984 9306 4651 10744 4458 10367 4055 9341 4051 9461 4041 9393 3555 8332 3730 8615 3772 8809 3733 8707 4189 9729 4175 9694 4009 9328 4646 10843 4113 9610 4104 9565 3924 9109 4092 9526 3542 8107 3967 9220 3799 8872 3752 8660 4156 9648 4120 9592 4008 9295 4474 10352 4195 9728 3876 9022 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 C a b 900 1800 2700 3600 4500 3924 4084 4051 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -lz -lm -lssl -lcrypto -lpthread -ldl
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 C a b 2K 4K 6K 8K 10K 9109 9473 9461 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -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 C a b 900 1800 2700 3600 4500 4092 4025 4041 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -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 C a b 2K 4K 6K 8K 10K 9526 9418 9393 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 8 - Warehouses: 500 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 8 - Warehouses: 500 C a b 800 1600 2400 3200 4000 3542 3783 3555 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 8 - Warehouses: 500 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 8 - Warehouses: 500 C a b 2K 4K 6K 8K 10K 8107 8737 8332 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -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 C a b 900 1800 2700 3600 4500 3967 3706 3730 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -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 C a b 2K 4K 6K 8K 10K 9220 8595 8615 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -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 C a b 800 1600 2400 3200 4000 3799 3724 3772 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -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 C a b 2K 4K 6K 8K 10K 8872 8677 8809 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 16 - Warehouses: 500 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 16 - Warehouses: 500 C a b 800 1600 2400 3200 4000 3752 3891 3733 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 16 - Warehouses: 500 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 16 - Warehouses: 500 C a b 2K 4K 6K 8K 10K 8660 9049 8707 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -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 C a b 900 1800 2700 3600 4500 4156 4238 4189 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -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 C a b 2K 4K 6K 8K 10K 9648 9849 9729 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -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 C a b 900 1800 2700 3600 4500 4120 4134 4175 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -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 C a b 2K 4K 6K 8K 10K 9592 9537 9694 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 32 - Warehouses: 500 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 32 - Warehouses: 500 C a b 900 1800 2700 3600 4500 4008 3984 4009 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 32 - Warehouses: 500 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 32 - Warehouses: 500 C a b 2K 4K 6K 8K 10K 9295 9306 9328 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -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 C a b 1000 2000 3000 4000 5000 4474 4651 4646 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -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 C a b 2K 4K 6K 8K 10K 10352 10744 10843 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -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 C a b 1000 2000 3000 4000 5000 4195 4458 4113 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -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 C a b 2K 4K 6K 8K 10K 9728 10367 9610 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 64 - Warehouses: 500 OpenBenchmarking.org New Orders Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 64 - Warehouses: 500 C a b 900 1800 2700 3600 4500 3876 4055 4104 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -lz -lm -lssl -lcrypto -lpthread -ldl
HammerDB - MariaDB Virtual Users: 64 - Warehouses: 500 OpenBenchmarking.org Transactions Per Minute, More Is Better HammerDB - MariaDB 10.9.3 Virtual Users: 64 - Warehouses: 500 C a b 2K 4K 6K 8K 10K 9022 9341 9565 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lnuma -lpcre2-8 -lcrypt -lsystemd -lz -lm -lssl -lcrypto -lpthread -ldl
Phoronix Test Suite v10.8.5