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.072K4K6K8K10K
* 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 July 2024.
KV, 50% Reads22.8%KV, 95% Reads21.6%KV, 60% Reads20.9%MoVR17.1%KV, 10% Reads17.6%Workload Option PopularityOpenBenchmarking.org
25620.1%51223.5%102417.6%12838.8%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 514 public results since 17 December 2022 with the latest data as of 23 July 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
95th
13
110506 +/- 7105
95th
4
107122 +/- 1801
93rd
4
99876 +/- 3418
92nd
3
98573 +/- 6336
92nd
4
97357 +/- 7139
89th
3
93450 +/- 8072
87th
5
91862 +/- 745
85th
3
89006 +/- 1032
85th
4
88816 +/- 675
83rd
17
86114 +/- 10381
81st
4
82730 +/- 2647
81st
3
82599 +/- 2741
78th
15
75436 +/- 7854
Mid-Tier
75th
< 73921
72nd
11
70414 +/- 6090
70th
15
69764 +/- 8969
67th
4
66776 +/- 7432
63rd
7
64827 +/- 3629
63rd
4
64154 +/- 203
61st
11
63730 +/- 4834
59th
5
59962 +/- 213
59th
9
59362 +/- 8279
56th
5
55882 +/- 6089
55th
3
53547 +/- 192
Median
50th
49937
49th
5
49420 +/- 2475
48th
11
48568 +/- 2772
48th
5
48508 +/- 1570
47th
12
48001 +/- 2291
45th
6
46054 +/- 2439
44th
16
44559 +/- 5059
40th
7
42090 +/- 1543
39th
7
41551 +/- 77
35th
4
34182 +/- 281
33rd
7
33276 +/- 1275
32nd
5
31687 +/- 1092
32nd
4
31426 +/- 2932
31st
4
30443 +/- 19
29th
3
29881 +/- 226
28th
5
29128 +/- 43
28th
4
29096 +/- 57
27th
4
27725 +/- 2860
Low-Tier
25th
< 25248
24th
3
22857 +/- 255
22nd
3
21689 +/- 55
21st
3
20215 +/- 469
20th
4
19001 +/- 83
16th
8
15336 +/- 1669
16th
3
15210 +/- 969
15th
4
14613 +/- 47
12th
4
12985 +/- 134
11th
3
12784 +/- 370
9th
5
12418 +/- 698
8th
4
12081 +/- 43
4th
6
11773 +/- 793
2nd
3
10623 +/- 135
2nd
3
8349 +/- 38
OpenBenchmarking.orgDistribution Of Public Results - Workload: KV, 50% Reads - Concurrency: 128478 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-Time612182430Min: 2 / Avg: 6 / Max: 25

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.19 / Max: 2

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

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

1 System - 91 Benchmark Results

2 x AMD EPYC 9684X 96-Core - AMD Titanite_4G - AMD Device 14a4

Ubuntu 24.04 - 6.8.0-11-generic - GNOME Shell 45.3

5 Systems - 587 Benchmark Results

AMD Ryzen 5 8600G - ASRock B650 Pro RS - AMD Device 14e8

Ubuntu 23.10 - 6.7.3-060703-generic - GNOME Shell 45.2

Find More Test Results