Skip to content

Imbalanced read results in instability of sysbench select_random_ranges/select_random_points performance (-25%~8%) #4529

@Yui-Song

Description

@Yui-Song

Bug Report

Imbalanced read results in instability of sysbench select_range_point performance (-25%~8%, compared with the baseline)

What did you do?

  1. Deploy a cluster
  2. Turn on prepare plan cache
  3. Run sysbench select_range_point

What did you expect to see?

The TPS of multiple tests are stable.

What did you see instead?

origin_img_v2_ccf16cb0-9285-4318-96de-49e648d5a2bg

TPS:37778
middle_img_v2_df923f3d-2744-485d-9067-88babb8154bg
middle_img_v2_8df9678b-bd03-4478-b6f7-1d3fcbbd066g

TPS:54453
middle_img_v2_19fcb3d1-ae09-4a3e-8faa-98f82e6bba6g

middle_img_v2_5e512be1-6cd5-409f-b25b-80d72710054g

What version of PD are you using (pd-server -V)?

commit ae23d40

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions