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.
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2202159-PTS-MARIADB101 mariadb 10.8.2 - Phoronix Test Suite 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&grw&rdt .
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: 1 mysqlslap: 8 mysqlslap: 16 mysqlslap: 32 mysqlslap: 64 mysqlslap: 128 mysqlslap: 256 mysqlslap: 512 mysqlslap: 1024 A B C 3862 2134 2068 1847 1170 507 313 328 386 3906 1762 1519 1248 816 395 321 330 377 3886 1783 1543 1221 904 407 321 313 393 OpenBenchmarking.org
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: 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
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: 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: 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: 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: 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: 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: 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
Phoronix Test Suite v10.8.4