There is a 16.5% performance regression when add index on ycsb db after PR#65111
- 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 add index ddl on ycsb (workloada) dataset.
### 2. What did you expect to see? (Required)
No performance regression.
### 3. What did you see instead (Required)
Duration regression 16.5% when add index on ycsb (workloada) compared to baseline 130.50 after #65111.
| description | tidb | tikv | pd | Duration avg |
| ----------------- | ------------------------------------------------------- | ---------------------------------------------------- | ------------------------------------------------ | ----------------------------------------------------------------------------------------------- |
| last success | pingcap/tidb@310e154c0214aed3d1752939cb8fd6ae2e0404e8 | tikv/tikv@147cacc5e3f783348797a099c7be7fe9e01eb013 | tikv/pd@9fe5653625628f54f7fe971b470a9969e63d8633 | 131.50, 131.50 |
| first regression | pingcap/tidb@a7bc5dfee3838944065363ee40991809cf6656ad | tikv/tikv@147cacc5e3f783348797a099c7be7fe9e01eb013 | tikv/pd@9fe5653625628f54f7fe971b470a9969e63d8633 | 152.00, 157.00 |
### 4. What is your TiDB version? (Required)
pingcap/tidb@a7bc5dfee3838944065363ee40991809cf6656ad
Contributor guide
Assessment
This issue has not been assessed yet.