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.

Sign up for GitHub

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

Jump to bottom

feat: optimize table xx compact limit 1000 #8241

Closed
Tracked by #7823
BohuTANG opened this issue Oct 16, 2022 · 1 comment · Fixed by #8322
Closed
Tracked by #7823

feat: optimize table xx compact limit 1000 #8241

BohuTANG opened this issue Oct 16, 2022 · 1 comment · Fixed by #8322
Assignees
@zhyass
Labels
C-feature Category: feature

Comments

@BohuTANG
Copy link
Member

BohuTANG commented Oct 16, 2022 •
edited
Loading

Summary

If a table is larger, such as 100TB, optimize table xx compact will take a long time, and if an error happens, the full compaction will be failed. We can add a limit to batch compaction.

optimize table xx compact limit 1000;

To pick 1000 the latest segments which need to compact.
@BohuTANG BohuTANG added the C-feature Category: feature label Oct 16, 2022
@BohuTANG
Copy link
Member Author

cc @zhyass @dantengsky

@BohuTANG BohuTANG mentioned this issue Oct 16, 2022
Closed
50 tasks
@BohuTANG BohuTANG changed the title feat: optimize table xx limit 1000 feat: optimize table xx compact limit 1000 Oct 17, 2022
@zhyass zhyass self-assigned this Oct 17, 2022
@zhyass zhyass mentioned this issue Oct 22, 2022
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@zhyass zhyass

Labels
C-feature Category: feature
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

fix: add a threshold for compact block zhyass/databend
2 participants
@BohuTANG @zhyass