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&gru .
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 mariadb: oltp_read_only - 16 mariadb: oltp_read_only - 32 mariadb: oltp_read_only - 64 mariadb: oltp_read_only - 128 mariadb: oltp_read_only - 256 mariadb: oltp_read_only - 512 mariadb: oltp_read_only - 768 mariadb: oltp_read_write - 16 mariadb: oltp_read_write - 32 mariadb: oltp_read_write - 64 mariadb: oltp_write_only - 16 mariadb: oltp_write_only - 32 mariadb: oltp_write_only - 64 mariadb: oltp_read_write - 128 mariadb: oltp_read_write - 256 mariadb: oltp_read_write - 512 mariadb: oltp_write_only - 128 mariadb: oltp_write_only - 256 mariadb: oltp_write_only - 512 mariadb: oltp_write_only - 768 mariadb: oltp_point_select - 16 mariadb: oltp_point_select - 32 mariadb: oltp_point_select - 64 mariadb: oltp_update_index - 16 mariadb: oltp_update_index - 32 mariadb: oltp_update_index - 64 mariadb: oltp_point_select - 128 mariadb: oltp_point_select - 256 mariadb: oltp_point_select - 512 mariadb: oltp_point_select - 768 mariadb: oltp_update_index - 128 mariadb: oltp_update_index - 256 mariadb: oltp_update_index - 512 mariadb: oltp_update_index - 768 mariadb: oltp_update_non_index - 16 mariadb: oltp_update_non_index - 32 mariadb: oltp_update_non_index - 64 mariadb: oltp_update_non_index - 128 mariadb: oltp_update_non_index - 256 mariadb: oltp_update_non_index - 512 mariadb: oltp_update_non_index - 768 mysqlslap: 32 mysqlslap: 64 mysqlslap: 128 mysqlslap: 256 mysqlslap: 512 mysqlslap: 1024 a 39412 38911 37346 36388 34885 33738 29969 64152 91042 126920 28971 44954 62523 140667 143808 134746 68457 71709 74356 68862 48253 50425 52074 4374 8700 14870 51582 50958 50187 48479 23988 34956 38428 38904 4345 8133 13148 20800 22368 22410 22274 397 350 282 200 125 79 OpenBenchmarking.org
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++
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: 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: 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: 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: 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_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_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 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: 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: 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 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_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: 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 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_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_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_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_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_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_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: 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_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: 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: 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_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: 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_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_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_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_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: 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: 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_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_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_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_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_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 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: 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 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: 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 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 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++
Phoronix Test Suite v10.8.5