SQL_tests_HPE_23042024_1941hrs

Intel Xeon Gold 6346 testing with a HPE Edgeline e920t (H10 BIOS) and Matrox MGA G200eH3 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 2404222-NE-SQLTESTSH70
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 6346 - Matrox MGA G200eH3 - HPE
April 22
  3 Hours, 46 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 6346 - Matrox MGA G200eH3 - HPE

Processor: Intel Xeon Gold 6346 @ 3.60GHz (16 Cores / 32 Threads), Motherboard: HPE Edgeline e920t (H10 BIOS), Chipset: Intel Device 0998, Memory: 64GB, Disk: 2 x 480GB HPE NS204i-p Gen10+ Boot + 2 x 960GB SAMSUNG MZ1L2960HCJR-00A07, Graphics: Matrox MGA G200eH3, Network: Intel I210 Backplane + 4 x Intel E810-C for SFP + 2 x Intel E810-XXV for SFP

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: 1024x768

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: Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0xd0003b9
Security Notes: gather_data_sampling: Mitigation of Microcode + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Mitigation of Clear buffers; SMT vulnerable + 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

SQL_tests_HPE_23042024_1941hrsOpenBenchmarking.orgPhoronix Test SuiteIntel Xeon Gold 6346 @ 3.60GHz (16 Cores / 32 Threads)HPE Edgeline e920t (H10 BIOS)Intel Device 099864GB2 x 480GB HPE NS204i-p Gen10+ Boot + 2 x 960GB SAMSUNG MZ1L2960HCJR-00A07Matrox MGA G200eH3Intel I210 Backplane + 4 x Intel E810-C for SFP + 2 x Intel E810-XXV for SFPUbuntu 22.045.15.0-105-generic (x86_64)1.3.255GCC 11.4.0ext41024x768ProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelVulkanCompilerFile-SystemScreen ResolutionSQL_tests_HPE_23042024_1941hrs 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 - Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0xd0003b9- gather_data_sampling: Mitigation of Microcode + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Mitigation of Clear buffers; SMT vulnerable + 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

SQL_tests_HPE_23042024_1941hrssysbench: RAM / Memorysysbench: CPUredis: GET - 1000redis: SET - 1000redis: LPOP - 1000redis: SADD - 1000redis: LPUSH - 1000pgbench: 1000 - 500 - Read Onlypgbench: 1000 - 500 - Read Only - Average Latencypgbench: 1000 - 500 - Read Writepgbench: 1000 - 500 - Read Write - Average LatencyIntel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE5233.4311442.36699639.13479711.39696805.63557465.96389557.312023662.4711170942.729OpenBenchmarking.org

Sysbench

This is a benchmark of Sysbench with the built-in CPU and memory sub-tests. Sysbench is a scriptable multi-threaded benchmark tool based on LuaJIT. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMiB/sec, More Is BetterSysbench 1.0.20Test: RAM / MemoryIntel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE11002200330044005500SE +/- 3.56, N = 35233.431. (CC) gcc options: -O2 -funroll-loops -rdynamic -ldl -laio -lm

OpenBenchmarking.orgEvents Per Second, More Is BetterSysbench 1.0.20Test: CPUIntel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE2K4K6K8K10KSE +/- 0.21, N = 311442.361. (CC) gcc options: -O2 -funroll-loops -rdynamic -ldl -laio -lm

Redis

Redis is an open-source in-memory data structure store, used as a database, cache, and message broker. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: GET - Parallel Connections: 1000Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE150K300K450K600K750KSE +/- 8665.55, N = 3699639.131. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SET - Parallel Connections: 1000Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE100K200K300K400K500KSE +/- 391.18, N = 3479711.391. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPOP - Parallel Connections: 1000Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE150K300K450K600K750KSE +/- 5505.67, N = 3696805.631. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SADD - Parallel Connections: 1000Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE120K240K360K480K600KSE +/- 1911.76, N = 3557465.961. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPUSH - Parallel Connections: 1000Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE80K160K240K320K400KSE +/- 4225.64, N = 12389557.311. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

PostgreSQL

This is a benchmark of PostgreSQL using the integrated pgbench for facilitating the database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 500 - Mode: Read OnlyIntel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE40K80K120K160K200KSE +/- 690.81, N = 32023661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average LatencyIntel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE0.5561.1121.6682.2242.78SE +/- 0.009, N = 32.4711. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 500 - Mode: Read WriteIntel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE3K6K9K12K15KSE +/- 106.27, N = 9117091. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL 16Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average LatencyIntel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE1020304050SE +/- 0.38, N = 942.731. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm

Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE

Processor: Intel Xeon Gold 6346 @ 3.60GHz (16 Cores / 32 Threads), Motherboard: HPE Edgeline e920t (H10 BIOS), Chipset: Intel Device 0998, Memory: 64GB, Disk: 2 x 480GB HPE NS204i-p Gen10+ Boot + 2 x 960GB SAMSUNG MZ1L2960HCJR-00A07, Graphics: Matrox MGA G200eH3, Network: Intel I210 Backplane + 4 x Intel E810-C for SFP + 2 x Intel E810-XXV for SFP

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: 1024x768

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: Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0xd0003b9
Security Notes: gather_data_sampling: Mitigation of Microcode + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Mitigation of Clear buffers; SMT vulnerable + 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 22 April 2024 21:41 by user peterf.