mariadb 10.8.2 AMD Ryzen 9 5950X 16-Core testing with a ASUS ROG CROSSHAIR VIII HERO (WI-FI) (3904 BIOS) and NVIDIA GeForce RTX 3070 Ti 8GB on Ubuntu 22.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2202159-PTS-MARIADB101&rdt&grs .
mariadb 10.8.2 Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server Display Driver OpenGL Vulkan Compiler File-System Screen Resolution A B C AMD Ryzen 9 5950X 16-Core @ 3.40GHz (16 Cores / 32 Threads) ASUS ROG CROSSHAIR VIII HERO (WI-FI) (3904 BIOS) AMD Starship/Matisse 32GB 1000GB Sabrent Rocket 4.0 Plus NVIDIA GeForce RTX 3070 Ti 8GB NVIDIA GA104 HD Audio ASUS MG28U Realtek RTL8125 2.5GbE + Intel I211 + Intel Wi-Fi 6 AX200 Ubuntu 22.04 5.15.0-18-generic (x86_64) GNOME Shell 41.3 X Server 1.20.14 NVIDIA 510.47.03 4.6.0 1.3.194 GCC 11.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-bootstrap --enable-cet --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++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-serialization=2 --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-11-O5cEXJ/gcc-11-11.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-O5cEXJ/gcc-11-11.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-build-config=bootstrap-lto-lean --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: acpi-cpufreq schedutil (Boost: Enabled) - CPU Microcode: 0xa201016 Security Details - itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + 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 AMD retpoline IBPB: conditional IBRS_FW STIBP: always-on RSB filling + srbds: Not affected + tsx_async_abort: Not affected
mariadb 10.8.2 mysqlslap: 256 mysqlslap: 1 mysqlslap: 1024 mysqlslap: 512 mysqlslap: 128 mysqlslap: 64 mysqlslap: 32 mysqlslap: 16 mysqlslap: 8 A B C 313 3862 386 328 507 1170 1847 2068 2134 321 3906 377 330 395 816 1248 1519 1762 321 3886 393 313 407 904 1221 1543 1783 OpenBenchmarking.org
MariaDB Clients: 256 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 256 A B C 70 140 210 280 350 SE +/- 2.34, N = 3 SE +/- 1.30, N = 3 SE +/- 4.61, N = 3 313 321 321 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
MariaDB Clients: 1 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 1 A B C 800 1600 2400 3200 4000 SE +/- 31.20, N = 3 SE +/- 8.81, N = 3 SE +/- 5.03, N = 3 3862 3906 3886 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
MariaDB Clients: 1024 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 1024 A B C 90 180 270 360 450 SE +/- 7.26, N = 9 SE +/- 7.00, N = 9 SE +/- 9.74, N = 6 386 377 393 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
MariaDB Clients: 512 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 512 A B C 70 140 210 280 350 SE +/- 8.98, N = 6 SE +/- 6.87, N = 9 SE +/- 1.38, N = 3 328 330 313 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
MariaDB Clients: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 128 A B C 110 220 330 440 550 SE +/- 40.47, N = 6 SE +/- 7.78, N = 9 SE +/- 15.13, N = 6 507 395 407 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
MariaDB Clients: 64 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 64 A B C 300 600 900 1200 1500 SE +/- 53.59, N = 12 SE +/- 31.03, N = 9 SE +/- 63.43, N = 9 1170 816 904 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
MariaDB Clients: 32 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 32 A B C 400 800 1200 1600 2000 SE +/- 6.91, N = 3 SE +/- 84.31, N = 9 SE +/- 69.26, N = 11 1847 1248 1221 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
MariaDB Clients: 16 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 16 A B C 400 800 1200 1600 2000 SE +/- 7.53, N = 3 SE +/- 40.17, N = 12 SE +/- 10.18, N = 3 2068 1519 1543 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
MariaDB Clients: 8 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 8 A B C 500 1000 1500 2000 2500 SE +/- 10.99, N = 3 SE +/- 70.20, N = 12 SE +/- 78.11, N = 9 2134 1762 1783 1. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lpcre2-8 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl
Phoronix Test Suite v10.8.5