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

20k+ 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.042K4K6K8K10K
* 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 13 April 2024.
KV, 50% Reads21.7%KV, 95% Reads20.5%KV, 60% Reads19.8%MoVR18.8%KV, 10% Reads19.2%Workload Option PopularityOpenBenchmarking.org
25622.1%51222.6%102419.3%12836.1%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 408 public results since 17 December 2022 with the latest data as of 20 March 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
94th
13
110506 +/- 7105
93rd
4
107122 +/- 1801
91st
4
99876 +/- 3418
90th
3
98573 +/- 6336
89th
4
97357 +/- 7139
87th
3
93450 +/- 8072
84th
14
90142 +/- 6398
83rd
3
89006 +/- 1032
83rd
4
88816 +/- 675
79th
4
82730 +/- 2647
79th
3
82599 +/- 2741
77th
12
79187 +/- 1336
Mid-Tier
75th
< 77441
70th
12
72939 +/- 6883
64th
8
66552 +/- 17
59th
7
64827 +/- 3629
57th
3
53547 +/- 192
54th
8
50183 +/- 220
51st
9
49066 +/- 1454
Median
50th
48890
50th
3
48273 +/- 327
48th
16
44559 +/- 5059
44th
7
41551 +/- 77
39th
4
34182 +/- 281
39th
6
33756 +/- 119
37th
3
32892 +/- 59
35th
3
29881 +/- 226
33rd
5
29128 +/- 43
33rd
4
27725 +/- 2860
30th
3
22857 +/- 255
26th
3
21689 +/- 55
Low-Tier
25th
< 20255
25th
3
20215 +/- 469
24th
3
19030 +/- 74
20th
8
15336 +/- 1669
20th
3
15210 +/- 969
18th
4
14613 +/- 47
14th
4
12985 +/- 134
13th
3
12784 +/- 370
13th
4
12700 +/- 349
9th
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: 128408 Results Range From 8305 To 132047 ops/s8305107801325515730182052068023155256302810530580330553553038005404804295545430479055038052855553305780560280627556523067705701807265575130776058008082555850308750589980924559493097405998801023551048301073051097801122551147301172051196801221551246301271051295801320551224364860

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 8 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: 7.97 / Max: 27

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

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

1 System - 4 Benchmark Results

ARMv8 Neoverse-N1 - QEMU KVM Virtual Machine - Red Hat QEMU PCIe

Ubuntu 22.04 - 5.15.0-1049-oracle - 1.3.238

1 System - 4 Benchmark Results

ARMv8 Neoverse-N1 - KVM Virtual Machine - Red Hat QEMU PCIe

Ubuntu 22.04 - 5.15.0-91-generic - 1.3.238

1 System - 4 Benchmark Results

AMD EPYC - KVM Standard PC - Intel 82G33

Ubuntu 22.04 - 5.15.0-91-generic - 1.3.238

1 System - 4 Benchmark Results

AMD EPYC - KVM Standard PC - Intel 82G33

Ubuntu 22.04 - 5.15.0-91-generic - 1.3.238

1 System - 10 Benchmark Results

Intel Core i5-6400T - LENOVO 30D2 - Intel Xeon E3-1200 v5

Ubuntu 22.04 - 6.2.0-39-generic - GNOME Shell 42.9

3 Systems - 880 Benchmark Results

2 Systems - 834 Benchmark Results

1 System - 756 Benchmark Results

8 Systems - 37 Benchmark Results

AMD Ryzen Threadripper 7980X 64-Cores - ASUS Pro WS TRX50-SAGE WIFI - AMD Device 14a4

Ubuntu 23.10 - 6.7.0-060700rc2-generic - GNOME Shell 45.0

1 System - 20 Benchmark Results

AMD Ryzen 9 5950X 16-Core - ASUS TUF GAMING B550-PLUS WIFI II - AMD Starship

Fedora Linux 39 - 6.5.11-300.fc39.x86_64 - KDE Plasma 5.27.9

1 System - 260 Benchmark Results

Intel Xeon Platinum 8375C - Amazon EC2 m6i.4xlarge - Intel 440FX 82441FX PMC

Ubuntu 20.04 - 5.15.0-1049-aws - GNOME Shell 3.36.9

1 System - 251 Benchmark Results

Intel Xeon Platinum 8358 - QEMU Standard PC - Intel 440FX 82441FX PMC

Ubuntu 20.04 - 5.15.0-1042-oracle - 1.1.182

Most Popular Test Results

OpenBenchmarking.org Results Compare

2 Systems - 361 Benchmark Results

AMD Ryzen Threadripper 3960X 24-Core - MSI Creator TRX40 - AMD Starship

Ubuntu 22.04 - 5.19.0-051900rc7-generic - GNOME Shell 42.2

2 Systems - 89 Benchmark Results

AMD Ryzen 7 3800XT 8-Core - MSI X370 XPOWER GAMING TITANIUM - AMD Starship

Debian 11 - 5.10.0-20-amd64 - X Server 1.20.11

2 Systems - 146 Benchmark Results

2 x Intel Xeon Gold 5220R - TYAN S7106 - Intel Sky Lake-E DMI3 Registers

Ubuntu 20.04 - 6.1.0-phx - GNOME Shell 3.36.9

3 Systems - 110 Benchmark Results

Intel Core i7-10700T - Logic Supply RXM-181 - Intel Comet Lake PCH

Ubuntu 22.04 - 5.15.0-52-generic - GNOME Shell 42.2

2 Systems - 133 Benchmark Results

2 x AMD EPYC 9654 96-Core - AMD Titanite_4G - AMD Device 14a4

Ubuntu 22.10 - 5.19.0-26-generic - GNOME Shell 43.0

2 Systems - 33 Benchmark Results

Intel Core i7-8565U - Dell 0KTW76 - Intel Cannon Point-LP

Ubuntu 22.04 - 5.19.0-rc6-phx-retbleed - GNOME Shell 42.2

3 Systems - 149 Benchmark Results

AMD Ryzen 9 7950X 16-Core - ASUS ROG CROSSHAIR X670E HERO - AMD Device 14d8

Ubuntu 22.10 - 6.2.0-rc1-phx - GNOME Shell 43.1

2 Systems - 201 Benchmark Results

AMD Ryzen 7 5800X3D 8-Core - ASUS ROG CROSSHAIR VIII HERO - AMD Starship

Ubuntu 22.04 - 5.17.0-1019-oem - GNOME Shell 42.2

2 Systems - 33 Benchmark Results

Intel Core i7-8565U - Dell 0KTW76 - Intel Cannon Point-LP

Ubuntu 22.04 - 5.19.0-rc6-phx-retbleed - GNOME Shell 42.2

2 Systems - 328 Benchmark Results

AMD Ryzen 9 3900XT 12-Core - MSI MEG X570 GODLIKE - AMD Starship

Ubuntu 22.04 - 5.15.0-53-generic - GNOME Shell 42.2

10 Systems - 272 Benchmark Results

AMD Ryzen 5 5600X 6-Core - ASUS ROG CROSSHAIR VIII HERO - AMD Starship

Ubuntu 22.04 - 5.19.0-46-generic - GNOME Shell 42.5

8 Systems - 271 Benchmark Results

AMD Ryzen 9 5900X 12-Core - ASUS ROG CROSSHAIR VIII HERO - AMD Starship

Ubuntu 22.04 - 5.19.0-46-generic - GNOME Shell 42.5

3 Systems - 191 Benchmark Results

Intel Core i5-12600K - ASUS PRIME Z690-P WIFI D4 - Intel Device 7aa7

Ubuntu 22.04 - 5.19.0-051900rc6daily20220716-generic - GNOME Shell 42.1

3 Systems - 197 Benchmark Results

2 x AMD EPYC 7773X 64-Core - AMD DAYTONA_X - AMD Starship

Ubuntu 22.04 - 5.15.0-47-generic - GNOME Shell 42.4

Find More Test Results