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&grr&sor .
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: 1024 mysqlslap: 512 mysqlslap: 128 mysqlslap: 64 mysqlslap: 256 mysqlslap: 32 mysqlslap: 8 mysqlslap: 16 mysqlslap: 1 A B C 386 328 507 1170 313 1847 2134 2068 3862 377 330 395 816 321 1248 1762 1519 3906 393 313 407 904 321 1221 1783 1543 3886 OpenBenchmarking.org
MariaDB Clients: 1024 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 1024 C A B 90 180 270 360 450 SE +/- 9.74, N = 6 SE +/- 7.26, N = 9 SE +/- 7.00, N = 9 393 386 377 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 B A C 70 140 210 280 350 SE +/- 6.87, N = 9 SE +/- 8.98, N = 6 SE +/- 1.38, N = 3 330 328 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 C B 110 220 330 440 550 SE +/- 40.47, N = 6 SE +/- 15.13, N = 6 SE +/- 7.78, N = 9 507 407 395 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 C B 300 600 900 1200 1500 SE +/- 53.59, N = 12 SE +/- 63.43, N = 9 SE +/- 31.03, N = 9 1170 904 816 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 C B A 70 140 210 280 350 SE +/- 4.61, N = 3 SE +/- 1.30, N = 3 SE +/- 2.34, N = 3 321 321 313 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: 8 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.8.2 Clients: 8 A C B 500 1000 1500 2000 2500 SE +/- 10.99, N = 3 SE +/- 78.11, N = 9 SE +/- 70.20, N = 12 2134 1783 1762 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 C B 400 800 1200 1600 2000 SE +/- 7.53, N = 3 SE +/- 10.18, N = 3 SE +/- 40.17, N = 12 2068 1543 1519 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 B C A 800 1600 2400 3200 4000 SE +/- 8.81, N = 3 SE +/- 5.03, N = 3 SE +/- 31.20, N = 3 3906 3886 3862 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