-
Notifications
You must be signed in to change notification settings - Fork 725
New issue
Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? # to your account
Duration of analyze partition table increased more than 50x #8500
Labels
Comments
/severity critical |
/assign @rleungx |
apollodafoni
changed the title
The time to analyze partition table increased more than 50x
Duration of analyze partition table increased more than 50x
Aug 7, 2024
Merged
The issue happens due to:
The above reason causes TSO requests to become very slow and affects the analyze table speed. |
ti-chi-bot bot
added a commit
that referenced
this issue
Aug 8, 2024
close #8500 Signed-off-by: Ryan Leung <rleungx@gmail.com> Co-authored-by: ti-chi-bot[bot] <108142056+ti-chi-bot[bot]@users.noreply.github.com>
# for free
to join this conversation on GitHub.
Already have an account?
# to comment
Bug Report
What did you do?
What did you expect to see?
Analyze finishes in a shorter time.
According to previous test experience, it is within 100s.
The most recent successful test was 37s.
What did you see instead?
"analyze time: "=1929.67098683
Sometimes it can be as long as 4,000 seconds .
A lot of time is spent on:
merging global stats for test.t1 columns
The performance degradation is very serious
What version of PD are you using (
pd-server -V
)?After testing, it was confirmed that this PR(#8377) caused it
The text was updated successfully, but these errors were encountered: