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

{ "title": "SQL_tests_HPE_23042024_1941hrs", "last_modified": "2024-04-23 00:05:04", "description": "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.", "systems": { "Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE": { "identifier": "Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE", "hardware": { "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" }, "software": { "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" }, "user": "peterf", "timestamp": "2024-04-22 21:41:58", "client_version": "10.8.4", "data": { "compiler-configuration": "--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-scaling-governor": "intel_pstate powersave (EPP: balance_performance)", "cpu-microcode": "0xd0003b9", "kernel-extra-details": "Transparent Huge Pages: madvise", "security": "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" } } }, "results": { "9b648f6fc67d3f2f4327a93a41bf3dd3a4a868af": { "identifier": "pts\/pgbench-1.14.0", "title": "PostgreSQL", "app_version": "16", "arguments": "-s 1000 -c 500", "description": "Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average Latency", "scale": "ms", "proportion": "LIB", "display_format": "BAR_GRAPH", "results": { "Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE": { "value": 42.7289999999999992041921359486877918243408203125, "raw_values": [ 40.40100000000000335376171278767287731170654296875, 43.27199999999999846522769075818359851837158203125, 42.6820000000000021600499167107045650482177734375, 43.2180000000000035242919693700969219207763671875, 42.88900000000000289901436190120875835418701171875, 44.7650000000000005684341886080801486968994140625, 42.0810000000000030695446184836328029632568359375, 42.56000000000000227373675443232059478759765625, 42.69500000000000028421709430404007434844970703125 ], "test_run_times": [ 433.490000000000009094947017729282379150390625, 432.8999999999999772626324556767940521240234375, 433.8799999999999954525264911353588104248046875, 433.08999999999997498889570124447345733642578125, 434.6100000000000136424205265939235687255859375, 435.490000000000009094947017729282379150390625, 434.16000000000002501110429875552654266357421875, 434.6100000000000136424205265939235687255859375, 432.759999999999990905052982270717620849609375 ], "details": { "compiler-options": { "compiler-type": "CC", "compiler": "gcc", "compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm" } } } } }, "7d420df109afad9e91cc0ae3a3d3949183d41318": { "identifier": "pts\/pgbench-1.14.0", "title": "PostgreSQL", "app_version": "16", "arguments": "-s 1000 -c 500", "description": "Scaling Factor: 1000 - Clients: 500 - Mode: Read Write", "scale": "TPS", "proportion": "HIB", "display_format": "BAR_GRAPH", "results": { "Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE": { "value": 11709, "raw_values": [ 12375.9234199999991687946021556854248046875, 11554.77842299999974784441292285919189453125, 11714.620918000000528991222381591796875, 11569.37599899999986519105732440948486328125, 11657.944672999999966123141348361968994140625, 11169.51329400000031455419957637786865234375, 11881.739847999999255989678204059600830078125, 11748.025648000000728643499314785003662109375, 11711.078561000000263447873294353485107421875 ], "test_run_times": [ 433.490000000000009094947017729282379150390625, 432.8999999999999772626324556767940521240234375, 433.8799999999999954525264911353588104248046875, 433.08999999999997498889570124447345733642578125, 434.6100000000000136424205265939235687255859375, 435.490000000000009094947017729282379150390625, 434.16000000000002501110429875552654266357421875, 434.6100000000000136424205265939235687255859375, 432.759999999999990905052982270717620849609375 ], "details": { "compiler-options": { "compiler-type": "CC", "compiler": "gcc", "compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm" } } } } }, "e8eac8c1fd2492817df64d8c5d59f8eaf4f976ec": { "identifier": "pts\/redis-1.4.0", "title": "Redis", "app_version": "7.0.4", "arguments": "-t lpush -c 1000", "description": "Test: LPUSH - Parallel Connections: 1000", "scale": "Requests Per Second", "proportion": "HIB", "display_format": "BAR_GRAPH", "results": { "Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE": { "value": 389557.3099999999976716935634613037109375, "raw_values": [ 405029.53000000002793967723846435546875, 396360.6599999999743886291980743408203125, 375928.4099999999743886291980743408203125, 402043.119999999995343387126922607421875, 377847.21999999997206032276153564453125, 374461.619999999995343387126922607421875, 405459.78000000002793967723846435546875, 401894.46999999997206032276153564453125, 387381.619999999995343387126922607421875, 404636.21999999997206032276153564453125, 378837.71999999997206032276153564453125, 364807.380000000004656612873077392578125 ], "test_run_times": [ 131.18000000000000682121026329696178436279296875, 134.69999999999998863131622783839702606201171875, 142.740000000000009094947017729282379150390625, 134.5, 143.18000000000000682121026329696178436279296875, 146.8600000000000136424205265939235687255859375, 135.849999999999994315658113919198513031005859375, 137.8799999999999954525264911353588104248046875, 143, 138.210000000000007958078640513122081756591796875, 147.400000000000005684341886080801486968994140625, 154.990000000000009094947017729282379150390625 ], "details": { "compiler-options": { "compiler-type": "CXX", "compiler": "g++", "compiler-options": "-MM -MT -g3 -fvisibility=hidden -O3" } } } } }, "230f35c07268717160cec601be8d111418eaacab": { "identifier": "pts\/pgbench-1.14.0", "title": "PostgreSQL", "app_version": "16", "arguments": "-s 1000 -c 500 -S", "description": "Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average Latency", "scale": "ms", "proportion": "LIB", "display_format": "BAR_GRAPH", "results": { "Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE": { "value": 2.471000000000000085265128291212022304534912109375, "raw_values": [ 2.47900000000000009237055564881302416324615478515625, 2.454000000000000181188397618825547397136688232421875, 2.479999999999999982236431605997495353221893310546875 ], "test_run_times": [ 439.6299999999999954525264911353588104248046875, 436.18000000000000682121026329696178436279296875, 436.18999999999999772626324556767940521240234375 ], "details": { "compiler-options": { "compiler-type": "CC", "compiler": "gcc", "compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm" } } } } }, "146780ffd426063fe4d7075d2af8ed9ee4d34e76": { "identifier": "pts\/pgbench-1.14.0", "title": "PostgreSQL", "app_version": "16", "arguments": "-s 1000 -c 500 -S", "description": "Scaling Factor: 1000 - Clients: 500 - Mode: Read Only", "scale": "TPS", "proportion": "HIB", "display_format": "BAR_GRAPH", "results": { "Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE": { "value": 202366, "raw_values": [ 201732.22315500001423060894012451171875, 203745.6218290000106208026409149169921875, 201618.8279329999932087957859039306640625 ], "test_run_times": [ 439.6299999999999954525264911353588104248046875, 436.18000000000000682121026329696178436279296875, 436.18999999999999772626324556767940521240234375 ], "details": { "compiler-options": { "compiler-type": "CC", "compiler": "gcc", "compiler-options": "-fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lm" } } } } }, "786a1b948e42a5743f23ca21c7f09ec4390d6f64": { "identifier": "pts\/redis-1.4.0", "title": "Redis", "app_version": "7.0.4", "arguments": "-t set -c 1000", "description": "Test: SET - Parallel Connections: 1000", "scale": "Requests Per Second", "proportion": "HIB", "display_format": "BAR_GRAPH", "results": { "Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE": { "value": 479711.390000000013969838619232177734375, "raw_values": [ 479320.8099999999976716935634613037109375, 479319.619999999995343387126922607421875, 480493.75 ], "test_run_times": [ 111.969999999999998863131622783839702606201171875, 112, 111.7300000000000039790393202565610408782958984375 ], "details": { "compiler-options": { "compiler-type": "CXX", "compiler": "g++", "compiler-options": "-MM -MT -g3 -fvisibility=hidden -O3" } } } } }, "a3880556362e473739f02a20cbdd73af1721fb5c": { "identifier": "pts\/redis-1.4.0", "title": "Redis", "app_version": "7.0.4", "arguments": "-t sadd -c 1000", "description": "Test: SADD - Parallel Connections: 1000", "scale": "Requests Per Second", "proportion": "HIB", "display_format": "BAR_GRAPH", "results": { "Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE": { "value": 557465.959999999962747097015380859375, "raw_values": [ 560416.25, 553884.5600000000558793544769287109375, 558097.0600000000558793544769287109375 ], "test_run_times": [ 96.2099999999999937472239253111183643341064453125, 97.8900000000000005684341886080801486968994140625, 96.8299999999999982946974341757595539093017578125 ], "details": { "compiler-options": { "compiler-type": "CXX", "compiler": "g++", "compiler-options": "-MM -MT -g3 -fvisibility=hidden -O3" } } } } }, "336fd32cb2c05fec4e5cd3e11c488269ccfa508f": { "identifier": "pts\/sysbench-1.1.0", "title": "Sysbench", "app_version": "1.0.20", "arguments": "cpu run", "description": "Test: CPU", "scale": "Events Per Second", "proportion": "HIB", "display_format": "BAR_GRAPH", "results": { "Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE": { "value": 11442.360000000000582076609134674072265625, "raw_values": [ 11442.139999999999417923390865325927734375, 11442.780000000000654836185276508331298828125, 11442.15999999999985448084771633148193359375 ], "test_run_times": [ 90.0199999999999960209606797434389591217041015625, 90.0199999999999960209606797434389591217041015625, 90.0199999999999960209606797434389591217041015625 ], "details": { "compiler-options": { "compiler-type": "CC", "compiler": "gcc", "compiler-options": "-O2 -funroll-loops -rdynamic -ldl -laio -lm" } } } } }, "54932796a66145b031c90ae71192fd11c85619ab": { "identifier": "pts\/redis-1.4.0", "title": "Redis", "app_version": "7.0.4", "arguments": "-t get -c 1000", "description": "Test: GET - Parallel Connections: 1000", "scale": "Requests Per Second", "proportion": "HIB", "display_format": "BAR_GRAPH", "results": { "Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE": { "value": 699639.130000000004656612873077392578125, "raw_values": [ 708569.1899999999441206455230712890625, 708037.4399999999441206455230712890625, 682310.75 ], "test_run_times": [ 78.659999999999996589394868351519107818603515625, 77.530000000000001136868377216160297393798828125, 80.68000000000000682121026329696178436279296875 ], "details": { "compiler-options": { "compiler-type": "CXX", "compiler": "g++", "compiler-options": "-MM -MT -g3 -fvisibility=hidden -O3" } } } } }, "d9a5e583346ee71b536710d3f6cfd23ad3e99cf1": { "identifier": "pts\/redis-1.4.0", "title": "Redis", "app_version": "7.0.4", "arguments": "-t lpop -c 1000", "description": "Test: LPOP - Parallel Connections: 1000", "scale": "Requests Per Second", "proportion": "HIB", "display_format": "BAR_GRAPH", "results": { "Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE": { "value": 696805.630000000004656612873077392578125, "raw_values": [ 685892.75, 703534.4399999999441206455230712890625, 700989.6899999999441206455230712890625 ], "test_run_times": [ 79.840000000000003410605131648480892181396484375, 78.0199999999999960209606797434389591217041015625, 78.280000000000001136868377216160297393798828125 ], "details": { "compiler-options": { "compiler-type": "CXX", "compiler": "g++", "compiler-options": "-MM -MT -g3 -fvisibility=hidden -O3" } } } } }, "63992f805edea5848af856d8bfe5fc1a5eedb68d": { "identifier": "pts\/sysbench-1.1.0", "title": "Sysbench", "app_version": "1.0.20", "arguments": "memory run", "description": "Test: RAM \/ Memory", "scale": "MiB\/sec", "proportion": "HIB", "display_format": "BAR_GRAPH", "results": { "Intel Xeon Gold 6346 - Matrox MGA G200eH3 - HPE": { "value": 5233.4300000000002910383045673370361328125, "raw_values": [ 5235.260000000000218278728425502777099609375, 5226.5600000000004001776687800884246826171875, 5238.47999999999956344254314899444580078125 ], "test_run_times": [ 19.57000000000000028421709430404007434844970703125, 19.60000000000000142108547152020037174224853515625, 19.559999999999998721023075631819665431976318359375 ], "details": { "compiler-options": { "compiler-type": "CC", "compiler": "gcc", "compiler-options": "-O2 -funroll-loops -rdynamic -ldl -laio -lm" } } } } } } }