clickhouse xeon ice lake 2 x Intel Xeon Platinum 8380 testing with a Intel M50CYP2SB2U (SE5C6200.86B.0022.D08.2103221623 BIOS) and ASPEED on Ubuntu 22.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2206251-NE-CLICKHOUS71 .
clickhouse xeon ice lake Processor Motherboard Chipset Memory Disk Graphics Monitor Network OS Kernel Desktop Display Server Vulkan Compiler File-System Screen Resolution A B C 2 x Intel Xeon Platinum 8380 @ 3.40GHz (80 Cores / 160 Threads) Intel M50CYP2SB2U (SE5C6200.86B.0022.D08.2103221623 BIOS) Intel Device 0998 16 x 32 GB DDR4-3200MT/s Hynix HMA84GR7CJR4N-XN 3841GB Micron_9300_MTFDHAL3T8TDP + 7682GB INTEL SSDPF2KX076TZ ASPEED VE228 2 x Intel X710 for 10GBASE-T + 2 x Intel E810-C for QSFP Ubuntu 22.04 5.15.0-40-generic (x86_64) GNOME Shell 42.2 X Server 1.21.1.3 1.2.204 GCC 11.2.0 ext4 1920x1080 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Processor Details - Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0xd000363 Security Details - itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Mitigation of Clear buffers; SMT vulnerable + 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 + srbds: Not affected + tsx_async_abort: Not affected
clickhouse xeon ice lake clickhouse: 100M Rows Web Analytics Dataset, First Run / Cold Cache clickhouse: 100M Rows Web Analytics Dataset, Second Run clickhouse: 100M Rows Web Analytics Dataset, Third Run A B C 221.45 225.04 226.18 221.81 225.38 220.10 220.91 230.48 229.82 OpenBenchmarking.org
ClickHouse 100M Rows Web Analytics Dataset, First Run / Cold Cache OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 100M Rows Web Analytics Dataset, First Run / Cold Cache A B C 50 100 150 200 250 SE +/- 1.43, N = 3 SE +/- 2.34, N = 3 SE +/- 2.70, N = 3 221.45 221.81 220.91 MIN: 36.34 / MAX: 5454.55 MIN: 36.79 / MAX: 5454.55 MIN: 34.88 / MAX: 5454.55 1. ClickHouse server version 22.7.1.687 (official build).
ClickHouse 100M Rows Web Analytics Dataset, Second Run OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 100M Rows Web Analytics Dataset, Second Run A B C 50 100 150 200 250 SE +/- 0.77, N = 3 SE +/- 3.55, N = 3 SE +/- 0.42, N = 3 225.04 225.38 230.48 MIN: 45.28 / MAX: 5454.55 MIN: 45.45 / MAX: 5454.55 MIN: 44.31 / MAX: 5454.55 1. ClickHouse server version 22.7.1.687 (official build).
ClickHouse 100M Rows Web Analytics Dataset, Third Run OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 100M Rows Web Analytics Dataset, Third Run A B C 50 100 150 200 250 SE +/- 2.94, N = 3 SE +/- 4.11, N = 3 SE +/- 4.87, N = 3 226.18 220.10 229.82 MIN: 44.51 / MAX: 5454.55 MIN: 40.21 / MAX: 2400 MIN: 43.26 / MAX: 6000 1. ClickHouse server version 22.7.1.687 (official build).
Phoronix Test Suite v10.8.4