pingcap / pingcap/tidb

There is a 3% performance regression in sysbench after PR#67030

Open
#67,434 4 comments 0 reactions 2 assignees Claimed by @baiyuqing View on GitHub
affects-9.0 component/pd severity/major type/bug type/performance type/regression
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Bug Report

### 1. Minimal reproduce step (Required)

1. Deploy a cluster with 3 TiDB and 3 Tikv.
2. Run benchmark sysbench (oltp_point_select).

### 2. What did you expect to see? (Required)

No performance regression.

### 3. What did you see instead (Required)

QPS regression in benchmark sysbench (oltp_point_select) compared to baseline 208227.92 after #67030.

| description | tidb | tikv | pd | QPS avg |
| ----------------- | ------------------------------------------------------- | ---------------------------------------------------- | ------------------------------------------------ | ----------------------------------------------------------------------------------------------- |
| last success | pingcap/tidb@0f44b08dc66a1bb7acfca227204db3fbf1024b38 | tikv/tikv@4d8fde720e7bbe80c25b70a6782f55e5b4ac1f2e | tikv/pd@d7b638033a145d22f8215f0ff2cbcd7ee0f0b961 | 208333.40, 207958.31 |
| first regression | pingcap/tidb@28ea9785662ffca1de9b2e0cc255d10a811d42a8 | tikv/tikv@4d8fde720e7bbe80c25b70a6782f55e5b4ac1f2e | tikv/pd@d7b638033a145d22f8215f0ff2cbcd7ee0f0b961 | 203409.21, 202808.92 |

### 4. What is your TiDB version? (Required)

pingcap/tidb@28ea9785662ffca1de9b2e0cc255d10a811d42a8

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.