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

* 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 22 November 2023.

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 353 public results since 17 December 2022 with the latest data as of 22 November 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)

AMD Ryzen Threadripper 7980X 64-Cores

100th

170530 ^{+/- 3312}

Intel Core i9-13900K

98th

166797 ^{+/- 1137}

AMD EPYC 7763 64-Core

91st

129471 ^{+/- 7062}

AMD Ryzen 9 7950X 16-Core

89th

125305 ^{+/- 9834}

2 x Intel Xeon Platinum 8380

88th

124479 ^{+/- 8007}

AMD EPYC 7713P 64-Core

88th

122623 ^{+/- 887}

AMD Ryzen 9 7950X3D 16-Core

87th

118438 ^{+/- 7488}

AMD EPYC 7513 32-Core

86th

117878 ^{+/- 807}

AMD Ryzen Threadripper 3990X 64-Core

80th

106372 ^{+/- 2045}

2 x Intel Xeon Platinum 8280

80th

105261 ^{+/- 6410}

AMD Ryzen Threadripper 3960X 24-Core

79th

103093 ^{+/- 22}

AMD Ryzen 9 7900X 12-Core

76th

100409 ^{+/- 1126}

Mid-Tier

75th

< 99710

AMD Ryzen Threadripper 3970X 32-Core

74th

98141 ^{+/- 10242}

Intel Core i9-10980XE

73rd

96525 ^{+/- 171}

AMD Ryzen 9 5950X 16-Core

73rd

96170 ^{+/- 5734}

AMD Ryzen 9 7900 12-Core

70th

94391 ^{+/- 596}

AMD Ryzen 9 7900X3D 12-Core

66th

92675 ^{+/- 257}

2 x Intel Xeon Gold 5220R

62nd

88516 ^{+/- 1514}

AMD Ryzen 7 7700X 8-Core

60th

87407 ^{+/- 942}

2 x AMD EPYC 7773X 64-Core

57th

84238 ^{+/- 6313}

AMD Ryzen 7 7700 8-Core

57th

84106 ^{+/- 866}

AMD Ryzen 7 7800X3D 8-Core

54th

81053 ^{+/- 874}

Intel Core i5-12600K

52nd

73837 ^{+/- 122}

Intel Core i5-13400

51st

69767 ^{+/- 154}

Intel Xeon Silver 4216

51st

69659

Median

50th

69659

AMD Ryzen 5 7600 6-Core

47th

65901 ^{+/- 645}

AMD Ryzen 5 7600X 6-Core

45th

65033 ^{+/- 393}

AMD Ryzen 9 3900XT 12-Core

42nd

64235 ^{+/- 95}

2 x AMD EPYC 9654 96-Core

41st

61369 ^{+/- 5158}

AMD Ryzen 7 5800X3D 8-Core

39th

60202 ^{+/- 762}

AMD Ryzen 7 5800X 8-Core

39th

60197 ^{+/- 166}

Intel Core i5-12400

35th

55927 ^{+/- 3944}

AMD EPYC 7551 32-Core

35th

54426 ^{+/- 1049}

Intel Xeon E-2388G

33rd

51882 ^{+/- 76}

AMD Ryzen 7 3800XT 8-Core

30th

47982 ^{+/- 177}

2 x Intel Xeon Silver 4215R

28th

46894 ^{+/- 318}

Intel Core i7-1280P

26th

42918 ^{+/- 325}

Low-Tier

25th

< 41003

AMD EPYC 7F32 8-Core

25th

39240

AMD Ryzen 7 PRO 5850U

23rd

36328 ^{+/- 145}

Intel Xeon E-2336

21st

35964 ^{+/- 67}

Intel Core i7-10700T

19th

30864 ^{+/- 252}

AMD Ryzen 7 PRO 6850U

17th

26935 ^{+/- 305}

Ampere ARMv8 Neoverse-N1 256-Core

17th

26809 ^{+/- 172}

Intel Core i7-1185G7

15th

23149 ^{+/- 114}

Intel Xeon E3-1280 v5

14th

22781 ^{+/- 675}

Intel Core i7-1165G7

12th

21847 ^{+/- 617}

AMD Ryzen 7 4800U

9th

18043 ^{+/- 74}

Intel Core i7-1065G7

6th

15666 ^{+/- 289}

Intel Core i7-8565U

5th

15510 ^{+/- 80}

AMD Ryzen 7 4700U

3rd

12948 ^{+/- 146}

AMD Ryzen 5 4500U

2nd

10015 ^{+/- 16}

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

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

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.

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

oci-benchmark-compare-flex3-1 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
oci-benchmark-compare-e4-1 1 System - 256 Benchmark Results	AMD EPYC 7J13 64-Core - QEMU Standard PC - Intel 440FX 82441FX PMC Ubuntu 20.04 - 5.15.0-1042-oracle - 1.1.182
oci-benchmark-compare-m6i-2 1 System - 241 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
oci-benchmark-compare-m6a-1 1 System - 275 Benchmark Results	AMD EPYC 7R13 - Amazon EC2 m6a.4xlarge - Intel 440FX 82441FX PMC Ubuntu 20.04 - 5.15.0-1048-aws - 1.1.182
2023-09-27-0020 1 System - 20 Benchmark Results	AMD Ryzen 9 5950X 16-Core - ASUS TUF GAMING B550-PLUS WIFI II - AMD Starship Fedora Linux 38 - 6.4.15-200.fc38.x86_64 - KDE Plasma 5.27.8
pts-multiple-24-intel-20230924 1 System - 352 Benchmark Results	2 x Intel Xeon Platinum 8452Y - Lenovo SB27A92818 v06 - 8 x 32 GB DDR5-4800MT AlmaLinux 9.2 - 5.14.0-284.30.1.el9_2.x86_64 - GCC 11.3.1 20221121
2023-09-09-0257 1 System - 20 Benchmark Results	AMD Ryzen 7 5700G - ASUS TUF GAMING B550-PLUS WIFI II - AMD Renoir Fedora Linux 38 - 6.4.14-200.fc38.x86_64 - KDE Plasma 5.27.7
2023-08-23-2352 1 System - 20 Benchmark Results	AMD Ryzen 7 5700G - ASUS TUF GAMING B550-PLUS WIFI II - AMD Renoir Fedora Linux 38 - 6.4.11-200.fc38.x86_64 - KDE Plasma 5.27.7
smoke test xeon e23 3 Systems - 369 Benchmark Results	Intel Xeon E-2388G - ASRockRack E3C252D4U - Intel Tiger Lake-H Ubuntu 22.04 - 6.2.0-26-generic - GNOME Shell 42.9
AMD Ryzen 5000 Series Linux Performance 10 Systems - 272 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
AMD Ryzen 5000 Series Linux Performance 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
AMD Ryzen 5000 Series Linux Performance 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
smoke ref 1 System - 563 Benchmark Results
smoke core 1 System - 42 Benchmark Results
Ryzen 7 5800X3D 2 Systems - 284 Benchmark Results	AMD Ryzen 7 5800X3D 8-Core - ASUS ROG CROSSHAIR VIII HERO - AMD Starship Ubuntu 22.04 - 5.19.0-46-generic - GNOME Shell 42.5

3800xt 2022 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
christmas comet 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
threadripper eo 2022 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
Linux 6.2 Retbleed 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
Linux 6.2 Kernel Benchmark Ryzen 9 7950X 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
EPYC Genoa Linux Distros 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
whiskey christmas 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
whiskey christmas 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
5800X3D 2023 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
epyc milan x xmas 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
tiger christrmas 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
Linux 6.2: 240 Threads Featured Processor Comparison	Intel Xeon Platinum 8490H - Quanta Cloud S6Q-MB-MPS - Intel Device 1bce Ubuntu 23.04 - 6.1.0-16-generic - GNOME Shell 43.2
AMD Ryzen 5000 Series Linux Performance Featured Processor Comparison	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
3970x new pre xmas 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
xeon platinum 8280 2023 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