roos-mysqlslap-8clients-luks-data-xfsdefault

Roos running on luks-data with default xfs settings: rw,relatime,attr2,inode64,logbufs=8,logbsize=256k,sunit=512,swidth=2048,noquota

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2209264-NE-ROOSMYSQL96
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
roos-mysqlslap-8clients-luks-data-xfsdefault
September 26 2022
  4 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):

roos-mysqlslap-8clients-luks-data-xfsdefault

Processor: 2 x Intel Xeon Gold 6138 (40 Cores / 80 Threads), Motherboard: Dell PowerEdge R640 [0HG0J8] (2.14.2 BIOS), Chipset: Intel Sky Lake-E DMI3 Registers, Memory: 8 x 32 GB DDR4-2400MT/s M393A4K40BB1-CRC, Disk: 3839GB PERC H750 Adp + 480GB DELLBOSS VD, Graphics: Matrox G200eW3, Network: 2 x Intel I350 + 4 x Intel 10-Gigabit X540-AT2

OS: Debian 11, Kernel: 5.15.53-1-pve (x86_64), Vulkan: 1.0.2, Compiler: GCC 10.2.1 20210110, File-System: xfs, Screen Resolution: 1600x1200

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --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-mutex --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-10-Km9U7s/gcc-10-10.2.1/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-10-Km9U7s/gcc-10-10.2.1/debian/tmp-gcn/usr,hsa --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: 0x2006d05
Security Notes: itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + mmio_stale_data: Mitigation of Clear buffers; SMT vulnerable + retbleed: Mitigation of IBRS + 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 IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Mitigation of Clear buffers; SMT vulnerable

roos-mysqlslap-8clients-luks-data-xfsdefaultOpenBenchmarking.orgPhoronix Test Suite2 x Intel Xeon Gold 6138 (40 Cores / 80 Threads)Dell PowerEdge R640 [0HG0J8] (2.14.2 BIOS)Intel Sky Lake-E DMI3 Registers8 x 32 GB DDR4-2400MT/s M393A4K40BB1-CRC3839GB PERC H750 Adp + 480GB DELLBOSS VDMatrox G200eW32 x Intel I350 + 4 x Intel 10-Gigabit X540-AT2Debian 115.15.53-1-pve (x86_64)1.0.2GCC 10.2.1 20210110xfs1600x1200ProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelVulkanCompilerFile-SystemScreen ResolutionRoos-mysqlslap-8clients-luks-data-xfsdefault BenchmarksSystem Logs- Transparent Huge Pages: madvise- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --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-mutex --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-10-Km9U7s/gcc-10-10.2.1/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-10-Km9U7s/gcc-10-10.2.1/debian/tmp-gcn/usr,hsa --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: 0x2006d05- itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + mmio_stale_data: Mitigation of Clear buffers; SMT vulnerable + retbleed: Mitigation of IBRS + 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 IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Mitigation of Clear buffers; SMT vulnerable

MariaDB

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

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.8.2Clients: 8roos-mysqlslap-8clients-luks-data-xfsdefault11002200330044005500SE +/- 14.01, N = 349261. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -pthread -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.8.2Clients: 1roos-mysqlslap-8clients-luks-data-xfsdefault2K4K6K8K10KSE +/- 47.08, N = 384271. (CXX) g++ options: -pie -fPIC -fstack-protector -O3 -pthread -lcrypt -lz -lm -lssl -lcrypto -lpthread -ldl

roos-mysqlslap-8clients-luks-data-xfsdefault

Processor: 2 x Intel Xeon Gold 6138 (40 Cores / 80 Threads), Motherboard: Dell PowerEdge R640 [0HG0J8] (2.14.2 BIOS), Chipset: Intel Sky Lake-E DMI3 Registers, Memory: 8 x 32 GB DDR4-2400MT/s M393A4K40BB1-CRC, Disk: 3839GB PERC H750 Adp + 480GB DELLBOSS VD, Graphics: Matrox G200eW3, Network: 2 x Intel I350 + 4 x Intel 10-Gigabit X540-AT2

OS: Debian 11, Kernel: 5.15.53-1-pve (x86_64), Vulkan: 1.0.2, Compiler: GCC 10.2.1 20210110, File-System: xfs, Screen Resolution: 1600x1200

Kernel Notes: Transparent Huge Pages: madvise
Compiler Notes: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --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-mutex --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-10-Km9U7s/gcc-10-10.2.1/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-10-Km9U7s/gcc-10-10.2.1/debian/tmp-gcn/usr,hsa --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: 0x2006d05
Security Notes: itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT vulnerable + mds: Mitigation of Clear buffers; SMT vulnerable + meltdown: Mitigation of PTI + mmio_stale_data: Mitigation of Clear buffers; SMT vulnerable + retbleed: Mitigation of IBRS + 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 IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Mitigation of Clear buffers; SMT vulnerable

Testing initiated at 26 September 2022 15:27 by user root.