Intel Core i3-12100 testing with a ASRock B660M-HDV (6.02 BIOS) and Intel ADL-S GT1 16GB 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 2206254-NE-CLICKHOUS01
{
"title": "clickhouse 2100",
"last_modified": "2022-06-25 15:28:25",
"description": "Intel Core i3-12100 testing with a ASRock B660M-HDV (6.02 BIOS) and Intel ADL-S GT1 16GB on Ubuntu 22.04 via the Phoronix Test Suite.",
"systems": {
"A": {
"identifier": "A",
"hardware": {
"Processor": "Intel Core i3-12100 @ 5.50GHz (4 Cores \/ 8 Threads)",
"Motherboard": "ASRock B660M-HDV (6.02 BIOS)",
"Chipset": "Intel Device 7aa7",
"Memory": "16GB",
"Disk": "512GB Sabrent",
"Graphics": "Intel ADL-S GT1 16GB (1400MHz)",
"Audio": "Realtek ALC897",
"Monitor": "DELL S2409W",
"Network": "Intel"
},
"software": {
"OS": "Ubuntu 22.04",
"Kernel": "5.18.0-051800-generic (x86_64)",
"Desktop": "GNOME Shell 42.1",
"Display Server": "X Server 1.20.14 + Wayland",
"OpenGL": "4.6 Mesa 22.0.1",
"Vulkan": "1.2.204",
"Compiler": "GCC 11.2.0",
"File-System": "ext4",
"Screen Resolution": "1920x1080"
},
"user": "phoronix",
"timestamp": "2022-06-25 14:25:23",
"client_version": "10.8.3",
"data": {
"cpu-scaling-governor": "intel_pstate powersave (EPP: balance_performance)",
"cpu-microcode": "0x1f",
"cpu-thermald": "2.4.9",
"kernel-extra-details": "Transparent Huge Pages: madvise",
"security": "itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy\/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected"
}
},
"B": {
"identifier": "B",
"hardware": {
"Processor": "Intel Core i3-12100 @ 5.50GHz (4 Cores \/ 8 Threads)",
"Motherboard": "ASRock B660M-HDV (6.02 BIOS)",
"Chipset": "Intel Device 7aa7",
"Memory": "16GB",
"Disk": "512GB Sabrent",
"Graphics": "Intel ADL-S GT1 16GB (1400MHz)",
"Audio": "Realtek ALC897",
"Monitor": "DELL S2409W",
"Network": "Intel"
},
"software": {
"OS": "Ubuntu 22.04",
"Kernel": "5.18.0-051800-generic (x86_64)",
"Desktop": "GNOME Shell 42.1",
"Display Server": "X Server 1.20.14 + Wayland",
"OpenGL": "4.6 Mesa 22.0.1",
"Vulkan": "1.2.204",
"Compiler": "GCC 11.2.0",
"File-System": "ext4",
"Screen Resolution": "1920x1080"
},
"user": "phoronix",
"timestamp": "2022-06-25 14:37:55",
"client_version": "10.8.3",
"data": {
"cpu-scaling-governor": "intel_pstate powersave (EPP: balance_performance)",
"cpu-microcode": "0x1f",
"cpu-thermald": "2.4.9",
"kernel-extra-details": "Transparent Huge Pages: madvise",
"security": "itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy\/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected"
}
},
"C": {
"identifier": "C",
"hardware": {
"Processor": "Intel Core i3-12100 @ 5.50GHz (4 Cores \/ 8 Threads)",
"Motherboard": "ASRock B660M-HDV (6.02 BIOS)",
"Chipset": "Intel Device 7aa7",
"Memory": "16GB",
"Disk": "512GB Sabrent",
"Graphics": "Intel ADL-S GT1 16GB (1400MHz)",
"Audio": "Realtek ALC897",
"Monitor": "DELL S2409W",
"Network": "Intel"
},
"software": {
"OS": "Ubuntu 22.04",
"Kernel": "5.18.0-051800-generic (x86_64)",
"Desktop": "GNOME Shell 42.1",
"Display Server": "X Server 1.20.14 + Wayland",
"OpenGL": "4.6 Mesa 22.0.1",
"Vulkan": "1.2.204",
"Compiler": "GCC 11.2.0",
"File-System": "ext4",
"Screen Resolution": "1920x1080"
},
"user": "phoronix",
"timestamp": "2022-06-25 14:52:19",
"client_version": "10.8.3",
"data": {
"cpu-scaling-governor": "intel_pstate powersave (EPP: balance_performance)",
"cpu-microcode": "0x1f",
"cpu-thermald": "2.4.9",
"kernel-extra-details": "Transparent Huge Pages: madvise",
"security": "itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy\/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected"
}
},
"D": {
"identifier": "D",
"hardware": {
"Processor": "Intel Core i3-12100 @ 5.50GHz (4 Cores \/ 8 Threads)",
"Motherboard": "ASRock B660M-HDV (6.02 BIOS)",
"Chipset": "Intel Device 7aa7",
"Memory": "16GB",
"Disk": "512GB Sabrent",
"Graphics": "Intel ADL-S GT1 16GB (1400MHz)",
"Audio": "Realtek ALC897",
"Monitor": "DELL S2409W",
"Network": "Intel"
},
"software": {
"OS": "Ubuntu 22.04",
"Kernel": "5.18.0-051800-generic (x86_64)",
"Desktop": "GNOME Shell 42.1",
"Display Server": "X Server 1.20.14 + Wayland",
"OpenGL": "4.6 Mesa 22.0.1",
"Vulkan": "1.2.204",
"Compiler": "GCC 11.2.0",
"File-System": "ext4",
"Screen Resolution": "1920x1080"
},
"user": "phoronix",
"timestamp": "2022-06-25 15:14:10",
"client_version": "10.8.3",
"data": {
"cpu-scaling-governor": "intel_pstate powersave (EPP: balance_performance)",
"cpu-microcode": "0x1f",
"cpu-thermald": "2.4.9",
"kernel-extra-details": "Transparent Huge Pages: madvise",
"security": "itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy\/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected"
}
}
},
"results": {
"d31a295ba0a3d334db8db72b3e025160d9eae487": {
"identifier": "pts\/clickhouse-1.0.0",
"title": "ClickHouse",
"description": "100M Rows Web Analytics Dataset, First Run \/ Cold Cache",
"scale": "Queries Per Minute, Geo Mean",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"A": {
"value": 85.68999999999999772626324556767940521240234375,
"raw_values": [
85.1332659647270020286669023334980010986328125,
86.376604272657999672446749173104763031005859375,
85.5618176043559941490457276813685894012451171875
],
"min_result": [
"6.99"
],
"max_result": [
"15000"
],
"test_run_times": [
191.080000000000012505552149377763271331787109375,
192.31000000000000227373675443232059478759765625,
195.5
],
"details": {
"install-footnote": "ClickHouse server version 22.7.1.687 (official build)."
}
},
"B": {
"value": 87.8299999999999982946974341757595539093017578125,
"raw_values": [
88.4870890152489977253935649059712886810302734375,
86.9513131828440037907057558186352252960205078125,
88.063728013309997777469106949865818023681640625
],
"min_result": [
"7.25"
],
"max_result": [
"15000"
],
"test_run_times": [
143.990000000000009094947017729282379150390625,
189.520000000000010231815394945442676544189453125,
191.81999999999999317878973670303821563720703125,
190.05000000000001136868377216160297393798828125
],
"details": {
"install-footnote": "ClickHouse server version 22.7.1.687 (official build)."
}
},
"C": {
"value": 88.43999999999999772626324556767940521240234375,
"raw_values": [
89.7024679588970030863492866046726703643798828125,
91.0690948352760045736431493423879146575927734375,
85.4519624568360001148903393186628818511962890625,
88.791061860691996798777836374938488006591796875,
87.160624307451001868685125373303890228271484375
],
"min_result": [
"6.79"
],
"max_result": [
"20000"
],
"test_run_times": [
184.590000000000003410605131648480892181396484375,
189.849999999999994315658113919198513031005859375,
191.969999999999998863131622783839702606201171875,
190.6100000000000136424205265939235687255859375,
190.8600000000000136424205265939235687255859375
],
"details": {
"install-footnote": "ClickHouse server version 22.7.1.687 (official build)."
}
},
"D": {
"value": 89.68000000000000682121026329696178436279296875,
"raw_values": [
92.288323941350000723105040378868579864501953125,
89.5553684986929994238380459137260913848876953125,
87.717623679495005717399180866777896881103515625,
89.16130459144500264301314018666744232177734375
],
"min_result": [
"6.88"
],
"max_result": [
"15000"
],
"test_run_times": [
183.93999999999999772626324556767940521240234375,
190.6100000000000136424205265939235687255859375,
191.979999999999989768184605054557323455810546875,
187.789999999999992041921359486877918243408203125
],
"details": {
"install-footnote": "ClickHouse server version 22.7.1.687 (official build)."
}
}
}
},
"5ce551f880e64bf1a4d06211f4f8669cac2f3e94": {
"identifier": "pts\/clickhouse-1.0.0",
"title": "ClickHouse",
"description": "100M Rows Web Analytics Dataset, Second Run",
"scale": "Queries Per Minute, Geo Mean",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"A": {
"value": 94.8599999999999994315658113919198513031005859375,
"raw_values": [
97.7249188278299953935857047326862812042236328125,
94.2355438898620008103534928523004055023193359375,
92.60849343700300551063264720141887664794921875
],
"min_result": [
"7.71"
],
"max_result": [
"30000"
],
"test_run_times": [
191.080000000000012505552149377763271331787109375,
192.31000000000000227373675443232059478759765625,
195.5
],
"details": {
"install-footnote": "ClickHouse server version 22.7.1.687 (official build)."
}
},
"B": {
"value": 97.650000000000005684341886080801486968994140625,
"raw_values": [
99.7724623621370056980595109052956104278564453125,
96.139968912217000251985155045986175537109375,
97.048367798968001807224936783313751220703125
],
"min_result": [
"7.76"
],
"max_result": [
"20000"
],
"test_run_times": [
143.990000000000009094947017729282379150390625,
189.520000000000010231815394945442676544189453125,
191.81999999999999317878973670303821563720703125,
190.05000000000001136868377216160297393798828125
],
"details": {
"install-footnote": "ClickHouse server version 22.7.1.687 (official build)."
}
},
"C": {
"value": 96.8599999999999994315658113919198513031005859375,
"raw_values": [
101.0539978948499992839060723781585693359375,
98.584806521318995464753243140876293182373046875,
95.7113198780590010983360116370022296905517578125,
93.201272343097997463701176457107067108154296875,
95.7550998936630008984138839878141880035400390625
],
"min_result": [
"7.73"
],
"max_result": [
"30000"
],
"test_run_times": [
184.590000000000003410605131648480892181396484375,
189.849999999999994315658113919198513031005859375,
191.969999999999998863131622783839702606201171875,
190.6100000000000136424205265939235687255859375,
190.8600000000000136424205265939235687255859375
],
"details": {
"install-footnote": "ClickHouse server version 22.7.1.687 (official build)."
}
},
"D": {
"value": 99.030000000000001136868377216160297393798828125,
"raw_values": [
102.3930719689600010724461753852665424346923828125,
100.8466591289299998379647149704396724700927734375,
94.489533029987995860210503451526165008544921875,
98.3723466991619943655678071081638336181640625
],
"min_result": [
"7.87"
],
"max_result": [
"30000"
],
"test_run_times": [
183.93999999999999772626324556767940521240234375,
190.6100000000000136424205265939235687255859375,
191.979999999999989768184605054557323455810546875,
187.789999999999992041921359486877918243408203125
],
"details": {
"install-footnote": "ClickHouse server version 22.7.1.687 (official build)."
}
}
}
},
"e1513066ea858892473846deb56a9e3c19210177": {
"identifier": "pts\/clickhouse-1.0.0",
"title": "ClickHouse",
"description": "100M Rows Web Analytics Dataset, Third Run",
"scale": "Queries Per Minute, Geo Mean",
"proportion": "HIB",
"display_format": "BAR_GRAPH",
"results": {
"A": {
"value": 96.969999999999998863131622783839702606201171875,
"raw_values": [
98.80222668454899803691660054028034210205078125,
96.2506188038939995976761565543711185455322265625,
95.8472130533049977429982391186058521270751953125
],
"min_result": [
"8.05"
],
"max_result": [
"30000"
],
"test_run_times": [
191.080000000000012505552149377763271331787109375,
192.31000000000000227373675443232059478759765625,
195.5
],
"details": {
"install-footnote": "ClickHouse server version 22.7.1.687 (official build)."
}
},
"B": {
"value": 97.409999999999996589394868351519107818603515625,
"raw_values": [
98.8754517586369985338023980148136615753173828125,
96.02342897063999771489761769771575927734375,
97.34019382233799433379317633807659149169921875
],
"min_result": [
"8.11"
],
"max_result": [
"20000"
],
"test_run_times": [
143.990000000000009094947017729282379150390625,
189.520000000000010231815394945442676544189453125,
191.81999999999999317878973670303821563720703125,
190.05000000000001136868377216160297393798828125
],
"details": {
"install-footnote": "ClickHouse server version 22.7.1.687 (official build)."
}
},
"C": {
"value": 95.599999999999994315658113919198513031005859375,
"raw_values": [
98.1248462697910071028672973625361919403076171875,
97.34765645776900555574684403836727142333984375,
95.7194234799359975340848905034363269805908203125,
93.302354085800999428101931698620319366455078125,
93.509067559518001644391915760934352874755859375
],
"min_result": [
"7.68"
],
"max_result": [
"20000"
],
"test_run_times": [
184.590000000000003410605131648480892181396484375,
189.849999999999994315658113919198513031005859375,
191.969999999999998863131622783839702606201171875,
190.6100000000000136424205265939235687255859375,
190.8600000000000136424205265939235687255859375
],
"details": {
"install-footnote": "ClickHouse server version 22.7.1.687 (official build)."
}
},
"D": {
"value": 95.849999999999994315658113919198513031005859375,
"raw_values": [
96.23797756279600434936583042144775390625,
94.1384498768640014532138593494892120361328125,
94.405319105035005122772417962551116943359375,
98.624053348600000390433706343173980712890625
],
"min_result": [
"7.68"
],
"max_result": [
"30000"
],
"test_run_times": [
183.93999999999999772626324556767940521240234375,
190.6100000000000136424205265939235687255859375,
191.979999999999989768184605054557323455810546875,
187.789999999999992041921359486877918243408203125
],
"details": {
"install-footnote": "ClickHouse server version 22.7.1.687 (official build)."
}
}
}
}
}
}