mariadb-64-threads

MariaDB Test on Ubuntu Server YS::Desktop using 24G RAM and 12vCPUs

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2405301-NE-MARIADB6476
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
MariaDB Test 64threads 24G-RAM 12vCPUs
May 29
  1 Hour, 56 Minutes
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):

MariaDB Test 64threads 24G-RAM 12vCPUs

Processor: Intel Core i7-1370P (6 Cores / 12 Threads), Motherboard: Dell Precision 3480 09NG45 (1.10.0 BIOS), Chipset: Intel 82G33/G31/P35/P31 + ICH9, Memory: 16 + 8 RAM, Disk: 57GB, Graphics: Intel Raptor Lake-P [Iris Xe ], Audio: QEMU Generic, Monitor: QEMU Monitor, Network: Red Hat Virtio 1.0 device

OS: Ubuntu 24.04, Kernel: 6.8.0-31-generic (x86_64), Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 1280x800, System Layer: vm-other

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --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-backtrace --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-defaulted --enable-offload-targets=nvptx-none=/build/gcc-13-uJ7kn6/gcc-13-13.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-13-uJ7kn6/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-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 Notes: CPU Microcode: 0x4114
Security Notes: gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + reg_file_data_sampling: Vulnerable: No microcode + retbleed: Not affected + spec_rstack_overflow: Not affected + 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; RSB filling; PBRSB-eIBRS: SW sequence; BHI: Syscall hardening KVM: SW loop + srbds: Not affected + tsx_async_abort: Not affected

mariadb-64-threadsOpenBenchmarking.orgPhoronix Test SuiteIntel Core i7-1370P (6 Cores / 12 Threads)Dell Precision 3480 09NG45 (1.10.0 BIOS)Intel 82G33/G31/P35/P31 + ICH916 + 8 RAM57GBIntel Raptor Lake-P [Iris Xe ]QEMU GenericQEMU MonitorRed Hat Virtio 1.0 deviceUbuntu 24.046.8.0-31-generic (x86_64)GCC 13.2.0ext41280x800vm-otherProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelCompilerFile-SystemScreen ResolutionSystem LayerMariadb-64-threads PerformanceSystem Logs- Transparent Huge Pages: madvise- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --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-backtrace --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-defaulted --enable-offload-targets=nvptx-none=/build/gcc-13-uJ7kn6/gcc-13-13.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-13-uJ7kn6/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-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 - CPU Microcode: 0x4114- gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + reg_file_data_sampling: Vulnerable: No microcode + retbleed: Not affected + spec_rstack_overflow: Not affected + 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; RSB filling; PBRSB-eIBRS: SW sequence; BHI: Syscall hardening KVM: SW loop + srbds: Not affected + tsx_async_abort: Not affected

mariadb-64-threadsmariadb: oltp_read_only - 64mariadb: oltp_read_write - 64mariadb: oltp_write_only - 64mariadb: oltp_point_select - 64mariadb: oltp_update_index - 64mariadb: oltp_update_non_index - 64MariaDB Test 64threads 24G-RAM 12vCPUs255136114463567376554991539491OpenBenchmarking.org

MariaDB

This is a MariaDB MySQL database server benchmark making use of sysbench rather than the existing pts/mysqlslap test profile that uses MariaDB with mysqlslap/mariadb-slap as the benchmark driver. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_read_only - Threads: 64MariaDB Test 64threads 24G-RAM 12vCPUs5K10K15K20K25KSE +/- 83.61, N = 3255131. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_read_write - Threads: 64MariaDB Test 64threads 24G-RAM 12vCPUs13K26K39K52K65KSE +/- 192.41, N = 3611441. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_write_only - Threads: 64MariaDB Test 64threads 24G-RAM 12vCPUs14K28K42K56K70KSE +/- 762.78, N = 3635671. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_point_select - Threads: 64MariaDB Test 64threads 24G-RAM 12vCPUs8K16K24K32K40KSE +/- 50.45, N = 3376551. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_update_index - Threads: 64MariaDB Test 64threads 24G-RAM 12vCPUs11K22K33K44K55KSE +/- 465.26, N = 3499151. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 11.5Test: oltp_update_non_index - Threads: 64MariaDB Test 64threads 24G-RAM 12vCPUs8K16K24K32K40KSE +/- 1654.47, N = 6394911. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl

MariaDB Test 64threads 24G-RAM 12vCPUs

Processor: Intel Core i7-1370P (6 Cores / 12 Threads), Motherboard: Dell Precision 3480 09NG45 (1.10.0 BIOS), Chipset: Intel 82G33/G31/P35/P31 + ICH9, Memory: 16 + 8 RAM, Disk: 57GB, Graphics: Intel Raptor Lake-P [Iris Xe ], Audio: QEMU Generic, Monitor: QEMU Monitor, Network: Red Hat Virtio 1.0 device

OS: Ubuntu 24.04, Kernel: 6.8.0-31-generic (x86_64), Compiler: GCC 13.2.0, File-System: ext4, Screen Resolution: 1280x800, System Layer: vm-other

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --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-backtrace --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-defaulted --enable-offload-targets=nvptx-none=/build/gcc-13-uJ7kn6/gcc-13-13.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-13-uJ7kn6/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-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 Notes: CPU Microcode: 0x4114
Security Notes: gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + reg_file_data_sampling: Vulnerable: No microcode + retbleed: Not affected + spec_rstack_overflow: Not affected + 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; RSB filling; PBRSB-eIBRS: SW sequence; BHI: Syscall hardening KVM: SW loop + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 29 May 2024 15:08 by user kerys.