Tests
Suites
Latest Results
Search
Register
Login
Popular Tests
Timed Linux Kernel Compilation
Blender
7-Zip Compression
SVT-AV1
FFmpeg
Newest Tests
OpenVINO GenAI
Rustls
LiteRT
WarpX
Epoch
Valkey
Recently Updated Tests
RELION
Llama.cpp
OpenVINO
Renaissance
Blender
vkpeak
New & Recently Updated Tests
Recently Updated Suites
Machine Learning
Server Motherboard
HPC - High Performance Computing
New & Recently Updated Suites
Component Benchmarks
CPUs / Processors
GPUs / Graphics
OpenGL
Disks / Storage
Motherboards
File-Systems
Operating Systems
OpenBenchmarking.org
Corporate / Organization Info
Bug Reports / Feature Requests
ClickHouse 1.1.0
pts/clickhouse-1.1.0
- 19 August 2022 -
Update against upstream, fix aarch64 usage.
downloads.xml
<?xml version="1.0"?> <!--Phoronix Test Suite v10.8.4--> <PhoronixTestSuite> <Downloads> <Package> <URL>https://github.com/ClickHouse/ClickHouse/releases/download/v22.5.4.19-stable/clickhouse-common-static-22.5.4.19-amd64.tgz</URL> <MD5>a5e573bae863eb852fc3b9b445d4a77c</MD5> <SHA256>a7ed440f46632884810c0131dc16256bdb3771f50846806003af1961edd1f82b</SHA256> <FileName>clickhouse-common-static-22.5.4.19-amd64.tgz</FileName> <FileSize>237338319</FileSize> <ArchitectureSpecific>x86_64</ArchitectureSpecific> </Package> <Package> <URL>https://github.com/ClickHouse/ClickHouse/releases/download/v22.5.4.19-stable/clickhouse-common-static-22.5.4.19-arm64.tgz</URL> <MD5>a3224bf28f80e461434cf9c670be87fd</MD5> <SHA256>5f8e17d6504958e38b211163f5ef64bbc3de51c6265edf62407054a24a770645</SHA256> <FileName>clickhouse-common-static-22.5.4.19-arm64.tgz</FileName> <FileSize>162809174</FileSize> <ArchitectureSpecific>aarch64</ArchitectureSpecific> </Package> <Package> <URL>https://raw.githubusercontent.com/ClickHouse/ClickHouse/v22.3.7.28-lts/benchmark/clickhouse/queries.sql</URL> <MD5>f1acbd265ff945b7d678ebf87d6dce6c</MD5> <SHA256>2164b9759dd796a7718ef9ac03a0031422c1948343de7417bfd385350cff0fb1</SHA256> <FileName>clickhouse_queries.sql</FileName> <FileSize>8074</FileSize> </Package> <Package> <URL>https://datasets.clickhouse.com/hits/partitions/hits_100m_obfuscated_v1.tar.xz</URL> <MD5>40200a88cbd311918bcd597333aa1912</MD5> <SHA256>972553f570405a6a632e95ccba057fdf264ca75771ba02de70b6cc6b24e52a0b</SHA256> <FileName>hits_100m_obfuscated_v1.tar.xz</FileName> <FileSize>9722280160</FileSize> </Package> </Downloads> </PhoronixTestSuite>
install.sh
#!/bin/sh # Based on https://clickhouse.com/docs/en/operations/performance-test/ if [ $OS_ARCH = "aarch64" ] then tar -xf clickhouse-common-static-22.5.4.19-arm64.tgz else tar -xf clickhouse-common-static-22.5.4.19-amd64.tgz fi tar -xf hits_100m_obfuscated_v1.tar.xz -C . echo $? > ~/install-exit-status mv hits_100m_obfuscated_v1/* . cd ~ CLICKHOUSE_CLIENT=clickhouse-common-static-22.5.4.19/usr/bin/clickhouse echo "#!/bin/bash TRIES=3 ./$CLICKHOUSE_CLIENT server 2>/dev/null & SERVER_PID=\$! sleep 5 ./$CLICKHOUSE_CLIENT client --query \"SELECT count() FROM hits_100m_obfuscated\" echo \$? > ~/test-exit-status cat clickhouse_queries.sql | sed \"s/{table}/hits_100m_obfuscated/g\" | while read query; do sync echo \"QUERY: \$query\" >> \$LOG_FILE for i in \$(seq 1 \$TRIES); do echo -n \"Clickhouse Query Time \$i: \" >> \$LOG_FILE ./$CLICKHOUSE_CLIENT client --time --format=Null --max_memory_usage=100G --query=\"\$query\" >> \$LOG_FILE 2>&1 retval=\$? if [ \$retval -ne 0 ]; then echo \$retval > ~/test-exit-status kill -9 \$SERVER_PID sleep 3 exit fi done done kill -9 \$SERVER_PID sleep 2 ./$CLICKHOUSE_CLIENT server --version > ~/pts-footnote 2>/dev/null" > clickhouse chmod +x clickhouse
results-definition.xml
<?xml version="1.0"?> <!--Phoronix Test Suite v10.8.4--> <PhoronixTestSuite> <ResultsParser> <OutputTemplate>Clickhouse Query Time 1: #_RESULT_#</OutputTemplate> <LineHint>Clickhouse Query Time 1:</LineHint> <MultiMatch>GEOMETRIC_MEAN</MultiMatch> <DivideResultDivisor>60</DivideResultDivisor> <ArgumentsDescription>100M Rows Web Analytics Dataset, First Run / Cold Cache</ArgumentsDescription> </ResultsParser> <ResultsParser> <OutputTemplate>Clickhouse Query Time 2: #_RESULT_#</OutputTemplate> <LineHint>Clickhouse Query Time 2:</LineHint> <MultiMatch>GEOMETRIC_MEAN</MultiMatch> <DivideResultDivisor>60</DivideResultDivisor> <ArgumentsDescription>100M Rows Web Analytics Dataset, Second Run</ArgumentsDescription> </ResultsParser> <ResultsParser> <OutputTemplate>Clickhouse Query Time 3: #_RESULT_#</OutputTemplate> <LineHint>Clickhouse Query Time 3:</LineHint> <MultiMatch>GEOMETRIC_MEAN</MultiMatch> <DivideResultDivisor>60</DivideResultDivisor> <ArgumentsDescription>100M Rows Web Analytics Dataset, Third Run</ArgumentsDescription> </ResultsParser> </PhoronixTestSuite>
test-definition.xml
<?xml version="1.0"?> <!--Phoronix Test Suite v10.8.4--> <PhoronixTestSuite> <TestInformation> <Title>ClickHouse</Title> <AppVersion>22.5.4.19</AppVersion> <Description>ClickHouse is an open-source, high performance OLAP data management system. This test profile uses ClickHouse's standard benchmark recommendations per https://clickhouse.com/docs/en/operations/performance-test/ with the 100 million rows web analytics dataset. The reported value is the query processing time using the geometric mean of all queries performed.</Description> <ResultScale>Queries Per Minute, Geo Mean</ResultScale> <Proportion>HIB</Proportion> <TimesToRun>3</TimesToRun> </TestInformation> <TestProfile> <Version>1.1.0</Version> <SupportedPlatforms>Linux</SupportedPlatforms> <SoftwareType>Application</SoftwareType> <TestType>System</TestType> <License>Free</License> <Status>Verified</Status> <SupportedArchitectures>x86_64, aarch64</SupportedArchitectures> <EnvironmentSize>26900</EnvironmentSize> <ProjectURL>https://clickhouse.com/</ProjectURL> <RepositoryURL>https://github.com/ClickHouse/ClickHouse</RepositoryURL> <Maintainer>Michael Larabel</Maintainer> </TestProfile> </PhoronixTestSuite>