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 3 December 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, 50% Reads - Concurrency: 128

OpenBenchmarking.org metrics for this test profile configuration based on 388 public results since 17 December 2022 with the latest data as of 28 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)

Intel Xeon Platinum 8468

100th

115841 ^{+/- 374}

Intel Core i9-13900K

94th

110506 ^{+/- 7105}

Intel Xeon Gold 6421N

94th

107122 ^{+/- 1801}

AMD EPYC 7763 64-Core

91st

99876 ^{+/- 3418}

2 x Intel Xeon Platinum 8380

90th

98573 ^{+/- 6336}

AMD EPYC 8534P 64-Core

89th

97357 ^{+/- 7139}

AMD EPYC 8534PN 64-Core

86th

93450 ^{+/- 8072}

AMD Ryzen 9 7950X3D 16-Core

84th

90142 ^{+/- 6398}

AMD EPYC 7713P 64-Core

83rd

89006 ^{+/- 1032}

AMD EPYC 7513 32-Core

83rd

88816 ^{+/- 675}

2 x Intel Xeon Platinum 8280

78th

82730 ^{+/- 2647}

AMD EPYC 8324P 32-Core

78th

82599 ^{+/- 2741}

AMD Ryzen 9 7900X 12-Core

76th

79187 ^{+/- 1336}

Mid-Tier

75th

< 78666

AMD Ryzen 9 7900X3D 12-Core

71st

73970 ^{+/- 50}

AMD Ryzen 9 5950X 16-Core

70th

72939 ^{+/- 6883}

AMD Ryzen Threadripper 3960X 24-Core

67th

70254 ^{+/- 352}

AMD Ryzen 7 7700X 8-Core

64th

66552 ^{+/- 17}

2 x AMD EPYC 7773X 64-Core

58th

64827 ^{+/- 3629}

Intel Core i5-12600K

57th

53547 ^{+/- 192}

AMD Ryzen 5 7600X 6-Core

54th

50183 ^{+/- 220}

AMD Ryzen 7 5800X3D 8-Core

51st

49066 ^{+/- 1454}

Median

50th

48890

AMD Ryzen 7 5800X 8-Core

50th

48273 ^{+/- 327}

2 x AMD EPYC 9654 96-Core

48th

44559 ^{+/- 5059}

Intel Xeon Silver 4216

46th

42331

Intel Xeon E-2388G

45th

41551 ^{+/- 77}

AMD Ryzen 7 3800XT 8-Core

41st

34182 ^{+/- 281}

AMD Ryzen 9 5900HX

40th

33756 ^{+/- 119}

Intel Core i7-1280P

38th

32892 ^{+/- 59}

AMD Ryzen 7 PRO 5850U

36th

29881 ^{+/- 226}

Intel Xeon E-2336

35th

29128 ^{+/- 43}

AMD Ryzen 9 3900XT 12-Core

34th

27725 ^{+/- 2860}

AMD Ryzen 7 PRO 6850U

31st

22857 ^{+/- 255}

AMD Ryzen Threadripper 3990X 64-Core

31st

22741 ^{+/- 60}

AMD EPYC 7F32 8-Core

30th

22291

Ampere ARMv8 Neoverse-N1 256-Core

29th

21837 ^{+/- 71}

Intel Core i7-10700T

28th

21689 ^{+/- 55}

Intel Core i9-10980XE

26th

20215 ^{+/- 469}

Low-Tier

25th

< 19322

Intel Core i7-1185G7

25th

19030 ^{+/- 74}

AMD Ryzen 5 5500U

21st

15336 ^{+/- 1669}

Intel Core i7-1165G7

21st

15210 ^{+/- 969}

AMD Ryzen 7 4800U

19th

14613 ^{+/- 47}

AMD Ryzen Threadripper 3970X 32-Core

16th

13163 ^{+/- 158}

Intel Core i7-8565U

15th

12985 ^{+/- 134}

Intel Core i7-1065G7

14th

12784 ^{+/- 370}

Intel Xeon E3-1280 v5

14th

12700 ^{+/- 349}

Intel Core i5-13400

9th

12081 ^{+/- 43}

2 x Intel Xeon Gold 5220R

5th

11773 ^{+/- 793}

AMD Ryzen 7 4700U

3rd

10623 ^{+/- 135}

AMD Ryzen 5 4500U

2nd

8349 ^{+/- 38}

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.

Based on public OpenBenchmarking.org results, the selected test / test configuration has an average standard deviation of 0.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.

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

Corsair MP700 PRO 2TB NVMe SSD Linux Benchmarks 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
2023-11-22-0403 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
oci-banchmark-compare-m6i-3 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
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
P620_Workstation_mixed 1 System - 36 Benchmark Results	AMD Ryzen Threadripper PRO 3955WX 16-Cores - LENOVO 1046 - AMD Starship Ubuntu 20.04 - 5.16.12-usb32-p620 - GNOME Shell 3.36.9
AMD Ryzen 5000 Series Linux Performance 10 Systems - 272 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
AMD Ryzen 5000 Series Linux Performance 8 Systems - 271 Benchmark Results	AMD Ryzen 5 5600G - ASUS ROG CROSSHAIR VIII HERO - AMD Renoir Ubuntu 22.04 - 5.19.0-46-generic - GNOME Shell 42.5

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
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
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
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
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.0.0-060000-generic - GNOME Shell 43.1
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
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
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
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
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
3900xt 2023 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