TiDB Community Server

This is a PingCAP TiDB Community Server benchmark facilitated using the sysbench OLTP database benchmarks.

To run this test with the Phoronix Test Suite, the basic command is: phoronix-test-suite benchmark tidb.

Project Site

pingcap.com

Source Repository

github.com

Test Created

7 September 2023

Test Maintainer

Michael Larabel 

Test Type

System

Average Install Time

5 Minutes, 11 Seconds

Average Run Time

20 Minutes, 53 Seconds

Accolades

5k+ Downloads

Supported Platforms


Public Result Uploads *Reported Installs **Reported Test Completions **Test Profile Page ViewsOpenBenchmarking.orgEventsTiDB Community Server Popularity Statisticspts/tidb2023.092023.102023.112023.122024.012024.022024.032024.042024.052004006008001000
* 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 8 May 2024.
oltp_read_write25.9%oltp_update_non_index27.0%oltp_point_select24.4%oltp_update_index22.8%Test Option PopularityOpenBenchmarking.org
3219.1%1619.8%25614.4%6416.9%12820.6%19.2%Threads Option PopularityOpenBenchmarking.org

Revision History

pts/tidb-1.0.3   [View Source]   Thu, 07 Sep 2023 19:03:19 GMT
Cleanup after test runs.

pts/tidb-1.0.2   [View Source]   Thu, 07 Sep 2023 15:00:07 GMT
Initial commit of TiDB database benchmark using sysbench.


Performance Metrics

Analyze Test Configuration:

TiDB Community Server 7.3

Test: oltp_update_non_index - Threads: 64

OpenBenchmarking.org metrics for this test profile configuration based on 70 public results since 7 September 2023 with the latest data as of 3 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
Queries Per Second (Average)
97th
6
58074 +/- 234
90th
4
50935 +/- 761
76th
4
43741 +/- 1957
76th
3
42770 +/- 1741
Mid-Tier
75th
< 41765
69th
3
40049 +/- 1116
61st
4
37398 +/- 506
54th
3
36382 +/- 287
Median
50th
34234
49th
5
34183 +/- 214
43rd
5
22231 +/- 2197
34th
4
19434 +/- 184
Low-Tier
25th
< 15795
19th
4
15530 +/- 33
OpenBenchmarking.orgDistribution Of Public Results - Test: oltp_update_non_index - Threads: 6470 Results Range From 3138 To 58287 Queries Per Second313842415344644775508653975610859119621306514168152711637417477185801968320786218892299224095251982630127404285072961030713318163291934022351253622837331384343953740640417434284643949450524615547258483614946450567516705277353876549795608257185582883691215

Based on OpenBenchmarking.org data, the selected test / test configuration (TiDB Community Server 7.3 - Test: oltp_update_non_index - Threads: 64) has an average run-time of 31 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 BenchmarkTest: oltp_update_non_index - Threads: 64Run-Time918273645Min: 10 / Avg: 30.38 / Max: 46

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
ARMv8 Neoverse-N1, ARMv8 Neoverse-V1