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):

SQL_tests_HPE_23042024_1941hrs - Phoronix Test Suite

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.

HTML result view exported from: https://openbenchmarking.org/result/2404222-NE-SQLTESTSH70&grr.

SQL_tests_HPE_23042024_1941hrsProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelVulkanCompilerFile-SystemScreen ResolutionIntel Xeon Gold 6346 - Matrox MGA G200eH3 - HPEIntel 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.0ext41024x768OpenBenchmarking.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,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_1941hrspgbench: 1000 - 500 - Read Write - Average Latencypgbench: 1000 - 500 - Read Writeredis: LPUSH - 1000pgbench: 1000 - 500 - Read Only - Average Latencypgbench: 1000 - 500 - Read Onlyredis: SET - 1000redis: SADD - 1000sysbench: CPUredis: GET - 1000redis: LPOP - 1000sysbench: RAM / MemoryIntel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE42.72911709389557.312.471202366479711.39557465.9611442.36699639.13696805.635233.43OpenBenchmarking.org

PostgreSQL

Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency

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

PostgreSQL

Scaling Factor: 1000 - Clients: 500 - Mode: Read Write

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

Redis

Test: LPUSH - Parallel Connections: 1000

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

Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency

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

PostgreSQL

Scaling Factor: 1000 - Clients: 500 - Mode: Read Only

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

Redis

Test: SET - Parallel Connections: 1000

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

Redis

Test: SADD - Parallel Connections: 1000

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

Sysbench

Test: CPU

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

Test: GET - Parallel Connections: 1000

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

Redis

Test: LPOP - Parallel Connections: 1000

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

Sysbench

Test: RAM / Memory

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

Phoronix Test Suite v10.8.4