Dell_MySQLSLap_0205_1107hrs

Intel Xeon Gold 5416S testing with a Dell 075K3T (1.8.0 BIOS) and Matrox G200eW3 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 2405026-NE-DELLMYSQL70
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
Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T
May 02
  4 Hours, 10 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):

Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T

Processor: Intel Xeon Gold 5416S (16 Cores / 32 Threads), Motherboard: Dell 075K3T (1.8.0 BIOS), Chipset: Intel Device 1bce, Memory: 64GB, Disk: 2 x 480GB Dell BOSS-N1 + 4 x 800GB KPM7XVUG800G, Graphics: Matrox G200eW3, Monitor: DELL MR2416, Network: 4 x Broadcom NetXtreme BCM5720 PCIe + 4 x Broadcom BCM57504 NetXtreme-E 10Gb/25Gb/40Gb/50Gb/100Gb/200Gb

OS: Ubuntu 22.04, Kernel: 5.15.0-105-generic (x86_64), Vulkan: 1.3.255, Compiler: GCC 11.4.0, File-System: ext4, Screen Resolution: 1920x1200

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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-XeT9lY/gcc-11-11.4.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-XeT9lY/gcc-11-11.4.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 Notes: CPU Microcode: 0x2b000571
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 + retbleed: Not affected + spec_rstack_overflow: 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 Enhanced IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Not affected + tsx_async_abort: Not affected

Dell_MySQLSLap_0205_1107hrsOpenBenchmarking.orgPhoronix Test SuiteIntel Xeon Gold 5416S (16 Cores / 32 Threads)Dell 075K3T (1.8.0 BIOS)Intel Device 1bce64GB2 x 480GB Dell BOSS-N1 + 4 x 800GB KPM7XVUG800GMatrox G200eW3DELL MR24164 x Broadcom NetXtreme BCM5720 PCIe + 4 x Broadcom BCM57504 NetXtreme-E 10Gb/25Gb/40Gb/50Gb/100Gb/200GbUbuntu 22.045.15.0-105-generic (x86_64)1.3.255GCC 11.4.0ext41920x1200ProcessorMotherboardChipsetMemoryDiskGraphicsMonitorNetworkOSKernelVulkanCompilerFile-SystemScreen ResolutionDell_MySQLSLap_0205_1107hrs PerformanceSystem Logs- 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,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-XeT9lY/gcc-11-11.4.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-XeT9lY/gcc-11-11.4.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 - CPU Microcode: 0x2b000571- 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: 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 Enhanced IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Not affected + tsx_async_abort: Not affected

Dell_MySQLSLap_0205_1107hrsmysqlslap: 8192mysqlslap: 4096mysqlslap: 2048mysqlslap: 1024mysqlslap: 512mysqlslap: 256mysqlslap: 128mysqlslap: 64mysqlslap: 32mysqlslap: 1Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T1021011001002104499621916362310567OpenBenchmarking.org

MariaDB mariadb-slap

This is a MariaDB MySQL database server benchmark making use of mysqlslap (mariadb-slap). Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 8192Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T20406080100SE +/- 0.04, N = 31021. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 4096Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T20406080100SE +/- 0.35, N = 31011. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 2048Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T20406080100SE +/- 0.23, N = 31001. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 1024Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T20406080100SE +/- 0.10, N = 31001. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 512Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T50100150200250SE +/- 0.21, N = 32101. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 256Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T100200300400500SE +/- 0.55, N = 34491. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 128Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T2004006008001000SE +/- 1.72, N = 39621. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 64Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T400800120016002000SE +/- 2.12, N = 319161. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 32Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T8001600240032004000SE +/- 34.33, N = 636231. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB mariadb-slap 11.5Clients: 1Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T2K4K6K8K10KSE +/- 132.91, N = 3105671. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -lnuma -lcrypt -laio -lz -lm -lssl -lcrypto -lpthread -ldl

10 Results Shown

MariaDB mariadb-slap:
  8192
  4096
  2048
  1024
  512
  256
  128
  64
  32
  1

Intel Xeon Gold 5416S - Matrox G200eW3 - Dell 075K3T

Processor: Intel Xeon Gold 5416S (16 Cores / 32 Threads), Motherboard: Dell 075K3T (1.8.0 BIOS), Chipset: Intel Device 1bce, Memory: 64GB, Disk: 2 x 480GB Dell BOSS-N1 + 4 x 800GB KPM7XVUG800G, Graphics: Matrox G200eW3, Monitor: DELL MR2416, Network: 4 x Broadcom NetXtreme BCM5720 PCIe + 4 x Broadcom BCM57504 NetXtreme-E 10Gb/25Gb/40Gb/50Gb/100Gb/200Gb

OS: Ubuntu 22.04, Kernel: 5.15.0-105-generic (x86_64), Vulkan: 1.3.255, Compiler: GCC 11.4.0, File-System: ext4, Screen Resolution: 1920x1200

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --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-XeT9lY/gcc-11-11.4.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-XeT9lY/gcc-11-11.4.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 Notes: CPU Microcode: 0x2b000571
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 + retbleed: Not affected + spec_rstack_overflow: 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 Enhanced IBRS IBPB: conditional RSB filling PBRSB-eIBRS: SW sequence + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 2 May 2024 01:07 by user peterf.