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

Add backend task pause|resume feature. #40041

Closed
5 tasks done
Benjamin2037 opened this issue Dec 19, 2022 · 4 comments · Fixed by #43159
Closed
5 tasks done

Add backend task pause|resume feature. #40041

Benjamin2037 opened this issue Dec 19, 2022 · 4 comments · Fixed by #43159
Assignees
@dhysum
Labels
sig/sql-infra SIG: SQL Infra type/feature-request Categorizes issue or PR as related to a new feature.

Comments

@Benjamin2037
Copy link
Collaborator

Benjamin2037 commented Dec 19, 2022 •
edited
Loading

Feature Request

This feature will make TiDB cluster can pause|resume one class of background tasks' execution, if the TiDB resource needs to be released to support higher priority foreground workload. For example DDL, Then, the backend tasks could be temporally paused and resume execution later.

We provide the command let user could operate background tasks by manually, also our resource manager will auto pause&resume background task according resource usage of the TiDB cluster.

Tasks
@Benjamin2037 Benjamin2037 added the type/feature-request Categorizes issue or PR as related to a new feature. label Dec 19, 2022
@Benjamin2037 Benjamin2037 self-assigned this Dec 19, 2022
@Benjamin2037 Benjamin2037 mentioned this issue Jan 11, 2023
Open
12 tasks
@Benjamin2037 Benjamin2037 mentioned this issue Jan 18, 2023
Open
12 tasks
@Benjamin2037 Benjamin2037 changed the title ddl: add backend task pause|resume feature. parser: add backend task pause|resume feature. Jan 18, 2023
@Benjamin2037 Benjamin2037 changed the title parser: add backend task pause|resume feature. Add backend task pause|resume feature. Jan 18, 2023
This was referenced Apr 15, 2023
Merged
Merged
Merged
Merged
@Benjamin2037
Copy link
Collaborator Author

/pick up dhysum

@Benjamin2037
Copy link
Collaborator Author

/pickup dhysum

@dhysum
Copy link
Contributor

dhysum commented Apr 20, 2023

/pick-up-challenge

ti-chi-bot pushed a commit that referenced this issue Apr 20, 2023
@dhysum
ddl: design doc for admin pause/resume ddl jobs (#43159)
3c82871 
ref #18015, close #40041
@zimulala zimulala reopened this Apr 20, 2023
@zimulala
Copy link
Contributor

/assign @dhysum

@Benjamin2037 Benjamin2037 added the sig/sql-infra SIG: SQL Infra label Apr 20, 2023
@dhysum dhysum mentioned this issue Apr 21, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Apr 28, 2023
@dhysum
ddl, parser, planner: admin Pause/Resume on DDL jobs (#43081)
d95ce84 
close #18015, ref #40041
@ti-chi-bot ti-chi-bot mentioned this issue May 4, 2023
Closed
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue May 9, 2023
@dhysum
ddl, executor: executor change for pause/resume on ddl jobs (#43171)
0d3ad53 
close #18015, ref #40041
@ti-chi-bot ti-chi-bot mentioned this issue May 9, 2023
Closed
12 tasks
dhysum added a commit to dhysum/tidb that referenced this issue May 10, 2023
@dhysum
ddl: design doc for admin pause/resume ddl jobs (pingcap#43159)
43e0b25 
ref pingcap#18015, close pingcap#40041
dhysum added a commit to dhysum/tidb that referenced this issue May 10, 2023
@dhysum
ddl, parser, planner: admin Pause/Resume on DDL jobs (pingcap#43081)
cc005bd 
close pingcap#18015, ref pingcap#40041
dhysum added a commit to dhysum/tidb that referenced this issue May 10, 2023
@dhysum
ddl, executor: executor change for pause/resume on ddl jobs (pingcap#…
9804b80 
…43171)

close pingcap#18015, ref pingcap#40041
This was referenced May 10, 2023
Closed
Merged
ti-chi-bot bot pushed a commit that referenced this issue May 10, 2023
@dhysum
ddl: background reorganization change for admin pause/resume ... (#…
5c31e16 
…43297)

close #18015, ref #40041
@ti-chi-bot ti-chi-bot mentioned this issue May 10, 2023
Closed
12 tasks
dhysum added a commit to dhysum/tidb that referenced this issue May 11, 2023
@dhysum
ddl: design doc for admin pause/resume ddl jobs (pingcap#43159)
b4333c2 
ref pingcap#18015, close pingcap#40041
dhysum added a commit to dhysum/tidb that referenced this issue May 11, 2023
@dhysum
ddl, parser, planner: admin Pause/Resume on DDL jobs (pingcap#43081)
954b725 
close pingcap#18015, ref pingcap#40041
dhysum added a commit to dhysum/tidb that referenced this issue May 11, 2023
@dhysum
ddl, executor: executor change for pause/resume on ddl jobs (pingcap#…
8565dbe 
…43171)

close pingcap#18015, ref pingcap#40041
dhysum added a commit to dhysum/tidb that referenced this issue May 11, 2023
@dhysum
ddl: background reorganization change for admin pause/resume ... (p…
cc58f85 
…ingcap#43297)

close pingcap#18015, ref pingcap#40041
ti-chi-bot bot pushed a commit that referenced this issue May 11, 2023
@dhysum
ddl, parser, executor, ddl worker: admin pause and resume ddl jobs (#…
18783b9 
…43674)

close #18015, ref #40041
@zimulala zimulala mentioned this issue May 11, 2023
Closed
17 tasks
@dhysum dhysum mentioned this issue Jun 12, 2023
Merged
16 tasks
@ran-huang ran-huang mentioned this issue Jun 15, 2023
Merged
16 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@dhysum dhysum

Labels
sig/sql-infra SIG: SQL Infra type/feature-request Categorizes issue or PR as related to a new feature.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

ddl: design doc for admin pause/resume ddl jobs dhysum/tidb
3 participants
@zimulala @Benjamin2037 @dhysum