pingcap / pingcap/tidb

There is a 16.5% performance regression when add index on ycsb db after PR#65111

Open
#65,368 0 comments 0 reactions 0 assignees View on GitHub
type/performance
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

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.