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

5k+ 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.038001600240032004000
* 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 current as of 15 March 2023.
KV, 50% Reads19.9%KV, 95% Reads19.8%KV, 60% Reads19.4%MoVR20.4%KV, 10% Reads20.5%Workload Option PopularityOpenBenchmarking.org
25623.1%51225.3%102423.9%12827.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, 50% Reads - Concurrency: 128

OpenBenchmarking.org metrics for this test profile configuration based on 203 public results since 17 December 2022 with the latest data as of 15 March 2023.

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)
96th
4
112245 +/- 1159
95th
11
110229 +/- 7747
93rd
3
98573 +/- 6336
87th
3
89006 +/- 1032
86th
4
88816 +/- 675
83rd
4
82730 +/- 2647
81st
6
73458 +/- 10025
Mid-Tier
75th
< 67666
75th
4
66356 +/- 1677
72nd
3
53547 +/- 192
69th
4
50139 +/- 188
66th
14
44725 +/- 5409
59th
4
34182 +/- 281
57th
6
33756 +/- 119
55th
3
32892 +/- 59
53rd
3
29881 +/- 226
52nd
3
22857 +/- 255
Median
50th
22793
44th
3
21689 +/- 55
43rd
3
20215 +/- 469
42nd
3
19030 +/- 74
35th
8
15336 +/- 1669
35th
3
15210 +/- 969
32nd
4
14613 +/- 47
Low-Tier
25th
< 13101
25th
4
12985 +/- 134
23rd
3
12784 +/- 370
23rd
4
12700 +/- 349
16th
4
12081 +/- 43
12th
7
11916 +/- 179
11th
5
11844 +/- 71
7th
6
11773 +/- 793
3rd
3
10623 +/- 135
2nd
3
8349 +/- 38
OpenBenchmarking.orgDistribution Of Public Results - Workload: KV, 50% Reads - Concurrency: 128200 Results Range From 8305 To 114295 ops/s830510425125451466516785189052102523145252652738529505316253374535865379854010542225443454646548585507055282554945570655918561305634256554567665697857190574025761457826580385825058462586745888659098593105952259734599465101585103705105825107945110065112185114305816243240

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 7 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.14 / Max: 27

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

3 Systems - 161 Benchmark Results

Intel Xeon Platinum 8275CL - Amazon EC2 c5.2xlarge - 16GB

Ubuntu 22.04.2 LTS - 5.15.0-1031-aws - 1.3.224

3 Systems - 161 Benchmark Results

AMD EPYC 7B13 - Google Compute Engine c2d-highcpu-8 - Intel 440FX 82441FX PMC

Ubuntu 22.04 - 5.15.0-1030-gcp - 1.3.224

2 Systems - 161 Benchmark Results

AMD EPYC 7B13 - Google Compute Engine c2d-highcpu-8 - Intel 440FX 82441FX PMC

Ubuntu 22.04 - 5.15.0-1030-gcp - 1.3.224

2 Systems - 160 Benchmark Results

Intel Xeon Platinum 8275CL - Amazon EC2 c5.2xlarge - 16GB

Ubuntu 22.04.2 LTS - 5.15.0-1031-aws - 1.3.224

1 System - 160 Benchmark Results

Intel Xeon Platinum 8275CL - Amazon EC2 c5.2xlarge - Intel 440FX 82441FX PMC

Ubuntu 22.04 - 5.15.0-1031-aws - 1.3.224

4 Systems - 137 Benchmark Results

AMD EPYC 7513 32-Core - Supermicro H12SSL-i v1.02 - 8 x 64 GB DDR4-3200MT

AlmaLinux 9.1 - 5.14.0-162.12.1.el9_1.x86_64 - GCC 11.3.1 20220421

2 Systems - 126 Benchmark Results

Ampere ARMv8 Neoverse-N1 - WIWYNN Mt.Jade - Ampere Computing LLC Altra PCI Root Complex A

Ubuntu 22.04 - 5.15.0-52-generic - GCC 11.3.0

3 Systems - 137 Benchmark Results

AMD EPYC 7713P 64-Core - Supermicro H12SSL-i v1.02 - 8 x 64 GB DDR4-3200MT

AlmaLinux 9.1 - 5.14.0-162.12.1.el9_1.x86_64 - GCC 11.3.1 20220421

2 Systems - 152 Benchmark Results

AMD Ryzen 9 5950X 16-Core - ASUS ROG CROSSHAIR VIII HERO - AMD Starship

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

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

1 System - 1 Benchmark Result

2 x Intel Xeon Silver 4215R - Supermicro X11DPG-OT-CPU v1.10 - Intel Sky Lake-E DMI3 Registers

Ubuntu 20.04 - 5.4.0-137-generic - X Server 1.20.13

1 System - 3 Benchmark Results

2 x Intel Xeon Silver 4215R - Supermicro X11DPG-OT-CPU v1.10 - Intel Sky Lake-E DMI3 Registers

Ubuntu 20.04 - 5.4.0-137-generic - X Server 1.20.13

1 System - 3 Benchmark Results

2 x Intel Xeon Silver 4215R - Supermicro X11DPG-OT-CPU v1.10 - Intel Sky Lake-E DMI3 Registers

Ubuntu 20.04 - 5.4.0-137-generic - X Server 1.20.13

1 System - 1 Benchmark Result

Rockchip ARMv8 Cortex-A76 - Radxa ROCK 5B - 16GB

Debian 11 - 5.10.66-27-rockchip-gea60d388902d - Xfce 4.16

Most Popular Test Results

OpenBenchmarking.org Results Compare

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

3 Systems - 73 Benchmark Results

Intel Core i7-1165G7 - Dell 0GG9PT - Intel Tiger Lake-LP

Ubuntu 21.10 - 5.13.0-52-generic - GNOME Shell 40.5

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

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 - 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 - 54 Benchmark Results

AMD Ryzen Threadripper 3970X 32-Core - ASUS ROG ZENITH II EXTREME - AMD Starship

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

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

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

3 Systems - 67 Benchmark Results

AMD Ryzen 7 PRO 5850U - HP 8A78 - AMD Renoir

Pop 22.04 - 5.19.0-76051900-generic - GNOME Shell 42.3.1

3 Systems - 31 Benchmark Results

Intel Core i7-1065G7 - Dell 06CDVY - Intel Ice Lake-LP DRAM

Ubuntu 22.04 - 5.18.8-051808-generic - GNOME Shell 42.2

2 Systems - 70 Benchmark Results

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

Ubuntu 20.04 - 6.1.0-rc8-phx - X Server

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 - 23 Benchmark Results

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

Ubuntu 22.04 - 5.18.8-051808-generic - GNOME Shell 42.2

2 Systems - 131 Benchmark Results

2 x Intel Xeon Platinum 8280 - GIGABYTE MD61-SC2-00 v01000100 - Intel Sky Lake-E DMI3 Registers

Ubuntu 21.04 - 5.11.0-49-generic - GNOME Shell 3.38.4

Find More Test Results