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.092K4K6K8K10K
* 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 18 September 2024.
KV, 50% Reads23.5%KV, 95% Reads22.3%KV, 60% Reads21.8%MoVR16.1%KV, 10% Reads16.4%Workload Option PopularityOpenBenchmarking.org
25619.0%51222.0%102416.5%12842.5%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, 50% Reads - Concurrency: 128

OpenBenchmarking.org metrics for this test profile configuration based on 631 public results since 17 December 2022 with the latest data as of 10 September 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)
100th
3
115841 +/- 374
96th
4
107122 +/- 1801
95th
4
99876 +/- 3418
94th
3
98573 +/- 6336
93rd
4
97357 +/- 7139
92nd
3
93450 +/- 8072
90th
5
91862 +/- 745
88th
3
89006 +/- 1032
88th
4
88816 +/- 675
85th
19
84174 +/- 11268
85th
4
82730 +/- 2647
85th
3
82599 +/- 2741
80th
17
73671 +/- 8877
79th
8
72974 +/- 607
Mid-Tier
75th
< 70273
73rd
13
68956 +/- 6602
72nd
17
68270 +/- 9390
71st
6
66640 +/- 401
66th
7
64827 +/- 3629
66th
4
64154 +/- 203
66th
7
64018 +/- 6281
65th
12
63103 +/- 5095
64th
7
61559 +/- 764
61st
5
59962 +/- 213
59th
11
58825 +/- 7501
56th
8
54215 +/- 5146
56th
3
53547 +/- 192
55th
9
51864 +/- 3243
Median
50th
49937
49th
7
48904 +/- 2204
48th
12
48209 +/- 2920
48th
7
48017 +/- 1532
47th
14
47545 +/- 2406
45th
8
45499 +/- 2303
44th
16
44559 +/- 5059
38th
9
42098 +/- 1336
37th
7
41551 +/- 77
32nd
4
34182 +/- 281
31st
5
33205 +/- 2325
30th
8
32915 +/- 1559
29th
8
31238 +/- 1032
29th
5
30546 +/- 3212
28th
4
30443 +/- 19
Low-Tier
25th
< 29169
25th
5
29128 +/- 43
25th
6
29087 +/- 46
24th
4
27725 +/- 2860
24th
3
27569 +/- 497
19th
3
21689 +/- 55
19th
4
21647 +/- 2429
18th
3
20215 +/- 469
17th
5
18984 +/- 82
14th
8
15336 +/- 1669
14th
3
15210 +/- 969
13th
4
14613 +/- 47
10th
4
12985 +/- 134
10th
3
12784 +/- 370
8th
5
12418 +/- 698
4th
6
11773 +/- 793
2nd
5
10675 +/- 119
2nd
3
8349 +/- 38
OpenBenchmarking.orgDistribution Of Public Results - Workload: KV, 50% Reads - Concurrency: 128631 Results Range From 8305 To 135458 ops/s83051084913393159371848121025235692611328657312013374536289388334137743921464654900951553540975664159185617296427366817693617190574449769937953782081846258716989713922579480197345998891024331049771075211100651126091151531176971202411227851253291278731304171329611355051224364860

Based on OpenBenchmarking.org data, the selected test / test configuration (CockroachDB 22.2 - Workload: KV, 50% 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, 50% Reads - Concurrency: 128Run-Time510152025Min: 2 / Avg: 5.86 / 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, 50% Reads - Concurrency: 128Deviation246810Min: 0 / Avg: 0.21 / Max: 4

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, 50% Reads - Concurrency: 12846812141632641.773.545.317.088.85

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

1 System - 1043 Benchmark Results

2 Systems - 413 Benchmark Results

Intel Core i7-1185G7 - Dell XPS 13 9310 0DXP1F - Intel Tiger Lake-LP

Ubuntu 24.04 - 6.10.0-061000rc4daily20240621-generic - 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

1 System - 192 Benchmark Results

AMD EPYC 8534P 64-Core - AMD Cinnabar - AMD Device 14a4

Ubuntu 23.10 - 6.8.1-060801-generic - GNOME Shell 45.2

Find More Test Results