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.

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
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
A
June 25 2022
  29 Minutes
B
June 25 2022
  36 Minutes
C
June 25 2022
  48 Minutes
D
June 25 2022
  38 Minutes
Invert Hiding All Results Option
  38 Minutes

Only show results where is faster than
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):

clickhouse 2100 - Phoronix Test Suite

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&export=pdf&sro&grw.

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.4