mariadb benchmarks AMD Ryzen Threadripper 7980X 64-Cores testing with a System76 Thelio Major (FA Z5 BIOS) and AMD Radeon Pro W7900 45GB on Ubuntu 23.10 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2403269-PTS-MARIADBB99&grr .
mariadb benchmarks Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server OpenGL Compiler File-System Screen Resolution a AMD Ryzen Threadripper 7980X 64-Cores @ 7.79GHz (64 Cores / 128 Threads) System76 Thelio Major (FA Z5 BIOS) AMD Device 14a4 4 x 32GB DRAM-4800MT/s Micron MTC20F1045S1RC48BA2 1000GB CT1000T700SSD5 AMD Radeon Pro W7900 45GB (1760/1124MHz) AMD Device 14cc DELL P2415Q Aquantia AQC113C NBase-T/IEEE + Realtek RTL8125 2.5GbE + Intel Wi-Fi 6 AX210/AX211/AX411 Ubuntu 23.10 6.5.0-25-generic (x86_64) GNOME Shell 45.2 X Server + Wayland 4.6 Mesa 23.2.1-1ubuntu3.1 (LLVM 15.0.7 DRM 3.54) GCC 13.2.0 ext4 1920x1080 OpenBenchmarking.org - Transparent Huge Pages: madvise - --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,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-defaulted --enable-offload-targets=nvptx-none=/build/gcc-13-XYspKM/gcc-13-13.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-13-XYspKM/gcc-13-13.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 - Scaling Governor: amd-pstate-epp powersave (EPP: balance_performance) - CPU Microcode: 0xa108105 - gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_rstack_overflow: Mitigation of Safe RET + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced / Automatic IBRS IBPB: conditional STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected
mariadb benchmarks mysqlslap: 1024 mariadb: oltp_write_only - 768 mariadb: oltp_write_only - 16 mariadb: oltp_write_only - 128 mariadb: oltp_read_write - 32 mysqlslap: 32 mysqlslap: 512 mariadb: oltp_read_write - 512 mariadb: oltp_read_write - 16 mariadb: oltp_write_only - 64 mariadb: oltp_write_only - 32 mysqlslap: 256 mariadb: oltp_read_write - 256 mysqlslap: 128 mysqlslap: 64 mariadb: oltp_point_select - 512 mariadb: oltp_point_select - 768 mariadb: oltp_update_non_index - 768 mariadb: oltp_update_index - 512 mariadb: oltp_point_select - 256 mariadb: oltp_point_select - 32 mariadb: oltp_point_select - 64 mariadb: oltp_update_index - 768 mariadb: oltp_update_non_index - 512 mariadb: oltp_point_select - 128 mariadb: oltp_update_non_index - 256 mariadb: oltp_update_index - 128 mariadb: oltp_update_non_index - 64 mariadb: oltp_update_index - 32 mariadb: oltp_update_index - 16 mariadb: oltp_update_non_index - 16 mariadb: oltp_update_non_index - 128 mariadb: oltp_update_index - 256 mariadb: oltp_update_non_index - 32 mariadb: oltp_update_index - 64 mariadb: oltp_point_select - 16 mariadb: oltp_write_only - 512 mariadb: oltp_read_write - 128 mariadb: oltp_read_write - 64 mariadb: oltp_write_only - 256 mariadb: oltp_read_only - 768 mariadb: oltp_read_only - 512 mariadb: oltp_read_only - 128 mariadb: oltp_read_only - 256 mariadb: oltp_read_only - 64 mariadb: oltp_read_only - 32 mariadb: oltp_read_only - 16 mariadb: oltp_read_write - 768 a 79 68862 28971 68457 91042 397 125 134746 64152 62523 44954 200 143808 282 350 50187 48479 22274 38428 50958 50425 52074 38904 22410 51582 22368 23988 13148 8700 4374 4345 20800 34956 8133 14870 48253 74356 140667 126920 71709 29969 33738 36388 34885 37346 38911 39412 OpenBenchmarking.org
MariaDB mariadb-slap Clients: 1024 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB mariadb-slap 11.5 Clients: 1024 a 20 40 60 80 100 SE +/- 1.09, N = 3 79 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_write_only - Threads: 768 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_write_only - Threads: 768 a 15K 30K 45K 60K 75K SE +/- 1463.11, N = 9 68862 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_write_only - Threads: 16 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_write_only - Threads: 16 a 6K 12K 18K 24K 30K SE +/- 788.87, N = 9 28971 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_write_only - Threads: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_write_only - Threads: 128 a 15K 30K 45K 60K 75K SE +/- 872.35, N = 9 68457 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_read_write - Threads: 32 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_read_write - Threads: 32 a 20K 40K 60K 80K 100K SE +/- 4547.59, N = 9 91042 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB mariadb-slap Clients: 32 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB mariadb-slap 11.5 Clients: 32 a 90 180 270 360 450 SE +/- 10.08, N = 9 397 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB mariadb-slap Clients: 512 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB mariadb-slap 11.5 Clients: 512 a 30 60 90 120 150 SE +/- 0.04, N = 3 125 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_read_write - Threads: 512 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_read_write - Threads: 512 a 30K 60K 90K 120K 150K SE +/- 1143.63, N = 8 134746 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_read_write - Threads: 16 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_read_write - Threads: 16 a 14K 28K 42K 56K 70K SE +/- 4254.52, N = 8 64152 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_write_only - Threads: 64 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_write_only - Threads: 64 a 13K 26K 39K 52K 65K SE +/- 2050.36, N = 6 62523 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_write_only - Threads: 32 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_write_only - Threads: 32 a 10K 20K 30K 40K 50K SE +/- 2531.25, N = 6 44954 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB mariadb-slap Clients: 256 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB mariadb-slap 11.5 Clients: 256 a 40 80 120 160 200 SE +/- 0.31, N = 3 200 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_read_write - Threads: 256 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_read_write - Threads: 256 a 30K 60K 90K 120K 150K SE +/- 1548.12, N = 5 143808 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB mariadb-slap Clients: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB mariadb-slap 11.5 Clients: 128 a 60 120 180 240 300 SE +/- 0.20, N = 3 282 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB mariadb-slap Clients: 64 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB mariadb-slap 11.5 Clients: 64 a 80 160 240 320 400 SE +/- 0.14, N = 3 350 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_point_select - Threads: 512 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_point_select - Threads: 512 a 11K 22K 33K 44K 55K SE +/- 246.77, N = 3 50187 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_point_select - Threads: 768 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_point_select - Threads: 768 a 10K 20K 30K 40K 50K SE +/- 109.95, N = 3 48479 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_update_non_index - Threads: 768 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_update_non_index - Threads: 768 a 5K 10K 15K 20K 25K SE +/- 20.38, N = 3 22274 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_update_index - Threads: 512 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_update_index - Threads: 512 a 8K 16K 24K 32K 40K SE +/- 315.94, N = 3 38428 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_point_select - Threads: 256 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_point_select - Threads: 256 a 11K 22K 33K 44K 55K SE +/- 127.62, N = 3 50958 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_point_select - Threads: 32 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_point_select - Threads: 32 a 11K 22K 33K 44K 55K SE +/- 94.79, N = 3 50425 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_point_select - Threads: 64 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_point_select - Threads: 64 a 11K 22K 33K 44K 55K SE +/- 68.06, N = 3 52074 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_update_index - Threads: 768 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_update_index - Threads: 768 a 8K 16K 24K 32K 40K SE +/- 473.89, N = 3 38904 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_update_non_index - Threads: 512 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_update_non_index - Threads: 512 a 5K 10K 15K 20K 25K SE +/- 259.47, N = 3 22410 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_point_select - Threads: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_point_select - Threads: 128 a 11K 22K 33K 44K 55K SE +/- 102.25, N = 3 51582 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_update_non_index - Threads: 256 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_update_non_index - Threads: 256 a 5K 10K 15K 20K 25K SE +/- 157.78, N = 3 22368 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_update_index - Threads: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_update_index - Threads: 128 a 5K 10K 15K 20K 25K SE +/- 142.96, N = 3 23988 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_update_non_index - Threads: 64 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_update_non_index - Threads: 64 a 3K 6K 9K 12K 15K SE +/- 40.46, N = 3 13148 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_update_index - Threads: 32 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_update_index - Threads: 32 a 2K 4K 6K 8K 10K SE +/- 41.97, N = 3 8700 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_update_index - Threads: 16 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_update_index - Threads: 16 a 900 1800 2700 3600 4500 SE +/- 30.99, N = 3 4374 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_update_non_index - Threads: 16 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_update_non_index - Threads: 16 a 900 1800 2700 3600 4500 SE +/- 11.69, N = 3 4345 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_update_non_index - Threads: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_update_non_index - Threads: 128 a 4K 8K 12K 16K 20K SE +/- 86.55, N = 3 20800 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_update_index - Threads: 256 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_update_index - Threads: 256 a 7K 14K 21K 28K 35K SE +/- 199.36, N = 3 34956 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_update_non_index - Threads: 32 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_update_non_index - Threads: 32 a 2K 4K 6K 8K 10K SE +/- 28.44, N = 3 8133 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_update_index - Threads: 64 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_update_index - Threads: 64 a 3K 6K 9K 12K 15K SE +/- 67.08, N = 3 14870 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_point_select - Threads: 16 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_point_select - Threads: 16 a 10K 20K 30K 40K 50K SE +/- 130.58, N = 3 48253 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_write_only - Threads: 512 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_write_only - Threads: 512 a 16K 32K 48K 64K 80K SE +/- 965.18, N = 3 74356 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_read_write - Threads: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_read_write - Threads: 128 a 30K 60K 90K 120K 150K SE +/- 182.88, N = 3 140667 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_read_write - Threads: 64 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_read_write - Threads: 64 a 30K 60K 90K 120K 150K SE +/- 559.56, N = 3 126920 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_write_only - Threads: 256 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_write_only - Threads: 256 a 15K 30K 45K 60K 75K SE +/- 406.82, N = 3 71709 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_read_only - Threads: 768 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_read_only - Threads: 768 a 6K 12K 18K 24K 30K SE +/- 127.49, N = 3 29969 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_read_only - Threads: 512 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_read_only - Threads: 512 a 7K 14K 21K 28K 35K SE +/- 99.25, N = 3 33738 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_read_only - Threads: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_read_only - Threads: 128 a 8K 16K 24K 32K 40K SE +/- 33.32, N = 3 36388 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_read_only - Threads: 256 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_read_only - Threads: 256 a 7K 14K 21K 28K 35K SE +/- 74.20, N = 3 34885 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_read_only - Threads: 64 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_read_only - Threads: 64 a 8K 16K 24K 32K 40K SE +/- 17.24, N = 3 37346 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_read_only - Threads: 32 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_read_only - Threads: 32 a 8K 16K 24K 32K 40K SE +/- 94.83, N = 3 38911 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
MariaDB Test: oltp_read_only - Threads: 16 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 11.5 Test: oltp_read_only - Threads: 16 a 8K 16K 24K 32K 40K SE +/- 83.35, N = 3 39412 1. (CXX) g++ options: -fPIC -pie -fstack-protector -O3 -shared -lrt -lpthread -lz -ldl -lm -lstdc++
Phoronix Test Suite v10.8.5