clickhouse 2100

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.

HTML result view exported from: https://openbenchmarking.org/result/2206254-NE-CLICKHOUS01&sro.

clickhouse 2100ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerOpenGLVulkanCompilerFile-SystemScreen ResolutionABCDIntel Core i3-12100 @ 5.50GHz (4 Cores / 8 Threads)ASRock B660M-HDV (6.02 BIOS)Intel Device 7aa716GB512GB SabrentIntel ADL-S GT1 16GB (1400MHz)Realtek ALC897DELL S2409WIntelUbuntu 22.045.18.0-051800-generic (x86_64)GNOME Shell 42.1X Server 1.20.14 + Wayland4.6 Mesa 22.0.11.2.204GCC 11.2.0ext41920x1080OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseProcessor Details- Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0x1f - Thermald 2.4.9 Security Details- 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

clickhouse 2100clickhouse: 100M Rows Web Analytics Dataset, First Run / Cold Cacheclickhouse: 100M Rows Web Analytics Dataset, Second Runclickhouse: 100M Rows Web Analytics Dataset, Third RunABCD85.6994.8696.9787.8397.6597.4188.4496.8695.6089.6899.0395.85OpenBenchmarking.org

ClickHouse

100M Rows Web Analytics Dataset, First Run / Cold Cache

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse100M Rows Web Analytics Dataset, First Run / Cold CacheABCD20406080100SE +/- 0.36, N = 3SE +/- 0.46, N = 3SE +/- 0.98, N = 5SE +/- 0.95, N = 485.6987.8388.4489.68MIN: 6.99 / MAX: 15000MIN: 7.25 / MAX: 15000MIN: 6.79 / MAX: 20000MIN: 6.88 / MAX: 150001. ClickHouse server version 22.7.1.687 (official build).

ClickHouse

100M Rows Web Analytics Dataset, Second Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse100M Rows Web Analytics Dataset, Second RunABCD20406080100SE +/- 1.51, N = 3SE +/- 1.09, N = 3SE +/- 1.35, N = 5SE +/- 1.72, N = 494.8697.6596.8699.03MIN: 7.71 / MAX: 30000MIN: 7.76 / MAX: 20000MIN: 7.73 / MAX: 30000MIN: 7.87 / MAX: 300001. ClickHouse server version 22.7.1.687 (official build).

ClickHouse

100M Rows Web Analytics Dataset, Third Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse100M Rows Web Analytics Dataset, Third RunABCD20406080100SE +/- 0.93, N = 3SE +/- 0.82, N = 3SE +/- 0.98, N = 5SE +/- 1.04, N = 496.9797.4195.6095.85MIN: 8.05 / MAX: 30000MIN: 8.11 / MAX: 20000MIN: 7.68 / MAX: 20000MIN: 7.68 / MAX: 300001. ClickHouse server version 22.7.1.687 (official build).

Phoronix Test Suite v10.8.5