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