pingcap / pingcap/tidb

The TPS of point-get drops to 0 while the QPS remains unchanged

Open
#53,819 4 comments 0 reactions 1 assignee Claimed by @cfzjywxk View on GitHub
severity/moderate sig/transaction type/bug
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

1. deploy a tidb cluster with 3 tidb + 3 tikv
2. run ycsb workloadc

### 2. What did you expect to see? (Required)
The TPS metric worked well.
| tidb | tikv| pd|
|---|---|---|
| [9c5981c1401a243af21ff1ba9d219710363a8f2f](https://github.com/pingcap/tidb/commit/9c5981c1401a243af21ff1ba9d219710363a8f2f)|[e106c8dd7237b95e8f26e064856b96b7fe384420](https://github.com/tikv/tikv/commit/e106c8dd7237b95e8f26e064856b96b7fe384420)|[740f15e6529ea7607be801fcc8a5747f96f6585d](https://github.com/tikv/pd/commit/740f15e6529ea7607be801fcc8a5747f96f6585d)|

|tps|qps|
|---|---|
| 74967 | 74942 |

![image](https://github.com/pingcap/tidb/assets/84501897/6bd81bc4-06d9-46dc-b36d-0eb5bc1d3cd3)

### 3. What did you see instead (Required)
The TPS of point dropped to nearly 0.
| tidb | tikv| pd|
|---|---|---|
| [203e5f2cff1d094166d67a144de3be0aa96bdef5](https://github.com/pingcap/tidb/commit/203e5f2cff1d094166d67a144de3be0aa96bdef5)|[e15796505d01ec56b01bd5a893accd0a186c3e32](https://github.com/tikv/tikv/commit/e15796505d01ec56b01bd5a893accd0a186c3e32)|[78cb08160a8e16a4704c5def5d44a50ae10f6e4c](https://github.com/tikv/pd/commit/78cb08160a8e16a4704c5def5d44a50ae10f6e4c)|

|tps|qps|
|---|---|
|25.2| 75615|

![image](https://github.com/pingcap/tidb/assets/84501897/0d4aab6b-189c-4b46-b563-b75eee526f97)

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

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.