Skip to content

There is a 6.0% performance regression in sysbench after PR#69452 #69765

Description

@mahjonp

Bug Report

1. Minimal reproduce step (Required)

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

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

No performance regression.

3. What did you see instead (Required)

QPS regression in benchmark sysbench (oltp_write_only) compared to baseline 59670.41 after #69452.

description tidb tikv pd QPS avg
last success a3e87c7 tikv/tikv@f8cd7fa tikv/pd@b9b3eed 59580.79, 59554.06
first regression e3dc39f tikv/tikv@f8cd7fa tikv/pd@b9b3eed 56096.05, 56159.44

4. What is your TiDB version? (Required)

e3dc39f

5. Root Cause Analysis

TiDB commit e3dc39f (integrate analyze resource control) introduces ALTER RESOURCE GROUP default BACKGROUND=(TASK_TYPES='stats') during bootstrap and refactors internal request source types

Metadata

Metadata

Assignees

No one assigned

    Labels

    contributionThis PR is from a community contributor.

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions