Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

commit 59bed2 causes high compile duration resulting in 33% performance regression in sysbench read-write workload #38919

Closed
Yui-Song opened this issue Nov 6, 2022 · 0 comments · Fixed by #38949
Assignees
Labels

Comments

@Yui-Song
Copy link
Contributor

Yui-Song commented Nov 6, 2022

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Deploy a tidb cluster with commit 510003d and commit 59bed2f and run sysbench oltp_read_write, oltp_read_only and hzbank workload

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

No performance regression.
image

3. What did you see instead (Required)

#38841 causes high compile duration resulting in 33% performance regression in sysbench read-write workload, 5% regression in read-only, 6%-7% regression in hzbank workload.
image

workload QPS before commit 59bed2f QPS after 59bed2f Diff(%)
read-write 83667 57645 -31.10%
read-onlly 106150 101941 -3.97%
hzbank 55123 51654 -6.29%

4. What is your TiDB version? (Required)

commit 59bed2f

@ti-chi-bot ti-chi-bot added may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.0 may-affects-6.1 may-affects-6.2 may-affects-6.3 labels Nov 6, 2022
@Yisaer Yisaer removed may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. may-affects-6.0 may-affects-6.1 may-affects-6.2 may-affects-6.3 labels Nov 7, 2022
@ChenPeng2013 ChenPeng2013 added the sig/planner SIG: Planner label Nov 9, 2022
@Yisaer Yisaer self-assigned this Nov 10, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging a pull request may close this issue.

5 participants