CockroachDB

CockroachDB is a cloud-native, distributed SQL database for data intensive applications. This test profile uses a server-less CockroachDB configuration to test various Coackroach workloads on the local host with a single node.

To run this test with the Phoronix Test Suite, the basic command is: phoronix-test-suite benchmark cockroach.

Project Site

cockroachlabs.com

Source Repository

github.com

Test Created

17 December 2022

Test Maintainer

Michael Larabel 

Test Type

System

Average Install Time

4 Seconds

Average Run Time

1 Minute, 49 Seconds

Test Dependencies

C/C++ Compiler Toolchain

Accolades

30k+ Downloads

Supported Platforms

Supported Architectures

x86_64 + aarch64

Public Result Uploads *Reported Installs **Reported Test Completions **Test Profile Page ViewsOpenBenchmarking.orgEventsCockroachDB Popularity Statisticspts/cockroach2022.122023.012023.022023.032023.042023.052023.062023.072023.082023.092023.102023.112023.122024.012024.022024.032024.042024.052024.062024.072024.082024.092024.102024.112K4K6K8K10K
* Uploading of benchmark result data to OpenBenchmarking.org is always optional (opt-in) via the Phoronix Test Suite for users wishing to share their results publicly.
** Data based on those opting to upload their test results to OpenBenchmarking.org and users enabling the opt-in anonymous statistics reporting while running benchmarks from an Internet-connected platform.
Data updated weekly as of 19 November 2024.
KV, 50% Reads23.7%KV, 95% Reads22.6%KV, 60% Reads22.0%MoVR15.7%KV, 10% Reads16.1%Workload Option PopularityOpenBenchmarking.org
25618.5%51221.7%102416.1%12843.7%Concurrency Option PopularityOpenBenchmarking.org

Revision History

pts/cockroach-1.0.2   [View Source]   Sat, 17 Dec 2022 17:37:46 GMT
Set TimesToRun = 3

pts/cockroach-1.0.1   [View Source]   Sat, 17 Dec 2022 16:11:52 GMT
Initial commit.

Suites Using This Test

Database Test Suite

Server


Performance Metrics

Analyze Test Configuration:

CockroachDB 22.2

Workload: KV, 95% Reads - Concurrency: 128

OpenBenchmarking.org metrics for this test profile configuration based on 643 public results since 17 December 2022 with the latest data as of 1 November 2024.

Below is an overview of the generalized performance for components where there is sufficient statistically significant data based upon user-uploaded results. It is important to keep in mind particularly in the Linux/open-source space there can be vastly different OS configurations, with this overview intended to offer just general guidance as to the performance expectations.

Component
Percentile Rank
# Compatible Public Results
ops/s (Average)
98th
14
163684 +/- 6265
98th
8
163180 +/- 468
97th
8
161384 +/- 6217
95th
10
151418 +/- 3114
90th
4
129471 +/- 7062
90th
16
126477 +/- 8678
88th
3
124479 +/- 8007
88th
7
123740 +/- 661
86th
3
122623 +/- 887
86th
19
121502 +/- 4592
86th
6
121133 +/- 2951
85th
5
120666 +/- 884
84th
4
117878 +/- 807
81st
8
112416 +/- 3252
79th
7
110100 +/- 1424
78th
4
105261 +/- 6410
76th
5
102152 +/- 396
Mid-Tier
75th
< 101973
74th
17
99831 +/- 1313
71st
3
96525 +/- 171
71st
13
95401 +/- 3594
70th
17
94499 +/- 5452
69th
12
94354 +/- 443
62nd
10
89000 +/- 1479
61st
6
88516 +/- 1514
60th
12
87304 +/- 766
57th
7
84238 +/- 6313
57th
16
83992 +/- 769
57th
5
83864 +/- 275
54th
4
83380 +/- 448
53rd
11
82284 +/- 1543
52nd
7
77621 +/- 273
Median
50th
73936
50th
3
73837 +/- 122
48th
7
69169 +/- 370
47th
7
67496 +/- 75
47th
7
67450 +/- 2892
44th
11
65428 +/- 824
40th
12
63930 +/- 1658
39th
13
62775 +/- 3615
38th
14
61369 +/- 5158
36th
8
60855 +/- 552
35th
14
59946 +/- 696
31st
9
56495 +/- 1962
30th
7
55927 +/- 3944
29th
7
55089 +/- 2085
29th
4
54426 +/- 1049
27th
7
51882 +/- 76
Low-Tier
25th
< 50025
25th
4
47982 +/- 177
24th
3
46894 +/- 318
22nd
4
42836 +/- 1985
22nd
5
42611 +/- 2296
22nd
8
42221 +/- 627
19th
6
39472 +/- 2203
18th
4
38677 +/- 243
18th
8
37780 +/- 4461
17th
6
37180 +/- 434
15th
5
35964 +/- 67
15th
4
34722 +/- 3215
14th
3
30864 +/- 252
12th
4
25642 +/- 2599
10th
8
23208 +/- 163
9th
5
22680 +/- 627
8th
4
21847 +/- 617
6th
4
18043 +/- 74
4th
3
15666 +/- 289
4th
4
15510 +/- 80
3rd
5
12889 +/- 130
2nd
3
10015 +/- 16
OpenBenchmarking.orgDistribution Of Public Results - Workload: KV, 95% Reads - Concurrency: 128643 Results Range From 9776 To 179034 ops/s97761316216548199342332026706300923347836864402504363647022504085379457180605666395267338707247411077496808828426887654910409442697812101198104584107970111356114742118128121514124900128286131672135058138444141830145216148602151988155374158760162146165532168918172304175690179076918273645

Based on OpenBenchmarking.org data, the selected test / test configuration (CockroachDB 22.2 - Workload: KV, 95% Reads - Concurrency: 128) has an average run-time of 6 minutes. By default this test profile is set to run at least 3 times but may increase if the standard deviation exceeds pre-defined defaults or other calculations deem additional runs necessary for greater statistical accuracy of the result.

OpenBenchmarking.orgMinutesTime Required To Complete BenchmarkWorkload: KV, 95% Reads - Concurrency: 128Run-Time510152025Min: 2 / Avg: 5.9 / Max: 22

Based on public OpenBenchmarking.org results, the selected test / test configuration has an average standard deviation of 0.2%.

OpenBenchmarking.orgPercent, Fewer Is BetterAverage Deviation Between RunsWorkload: KV, 95% Reads - Concurrency: 128Deviation246810Min: 0 / Avg: 0.2 / Max: 3

Does It Scale Well With Increasing Cores?

Yes, based on the automated analysis of the collected public benchmark data, this test / test settings does generally scale well with increasing CPU core counts. Data based on publicly available results for this test / test settings, separated by vendor, result divided by the reference CPU clock speed, grouped by matching physical CPU core count, and normalized against the smallest core count tested from each vendor for each CPU having a sufficient number of test samples and statistically significant data.

IntelAMDOpenBenchmarking.orgRelative Core Scaling To BaseCockroachDB CPU Core ScalingWorkload: KV, 95% Reads - Concurrency: 128468101214162432641.11252.2253.33754.455.5625

Tested CPU Architectures

This benchmark has been successfully tested on the below mentioned architectures. The CPU architectures listed is where successful OpenBenchmarking.org result uploads occurred, namely for helping to determine if a given test is compatible with various alternative CPU architectures.

CPU Architecture
Kernel Identifier
Verified On
Intel / AMD x86 64-bit
x86_64
(Many Processors)
ARMv8 64-bit
aarch64
Ampere ARMv8 Neoverse-N1 256-Core

Recent Test Results

OpenBenchmarking.org Results Compare

33 Systems - 367 Benchmark Results

1 System - 1 Benchmark Result

8 x AMD EPYC-Rome - Optimized Hosting KVM v0.36.18 - Intel 82G33

Ubuntu 24.04 - 6.8.0-39-generic - GCC 13.2.0

1 System - 8 Benchmark Results

8 x AMD EPYC-Rome - Optimized Hosting KVM v0.36.18 - Intel 82G33

Ubuntu 24.04 - 6.8.0-39-generic - GCC 13.2.0

4 Systems - 856 Benchmark Results

6 Systems - 344 Benchmark Results

AMD Ryzen AI 9 365 - ASUS Zenbook S 16 UM5606WA_UM5606WA UM5606WA v1.0 - AMD Device 1507

Ubuntu 24.10 - 6.11.0-rc6-phx - GNOME Shell 47.0

1 System - 1043 Benchmark Results

2 Systems - 413 Benchmark Results

AMD Ryzen 7 4700U - LENOVO IdeaPad 5 14ARE05 LNVNB161216 - AMD Renoir

Ubuntu 24.04 - 6.10.0-phx - GNOME Shell 46.0

1 System - 1002 Benchmark Results

1 System - 999 Benchmark Results

1 System - 389 Benchmark Results

AMD Ryzen Threadripper 7970X 32-Cores - ASRock TRX50 WS - AMD Device 14a4

Debian 12 - 6.1.0-22-amd64 - GNOME Shell 43.9

2 Systems - 1012 Benchmark Results

1 System - 1012 Benchmark Results

Find More Test Results