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

optimize execution of general DDL #53246

Open
1 of 6 tasks
D3Hunter opened this issue May 14, 2024 · 0 comments
Open
1 of 6 tasks

optimize execution of general DDL #53246

D3Hunter opened this issue May 14, 2024 · 0 comments

Comments

@D3Hunter
Copy link
Contributor

D3Hunter commented May 14, 2024

Enhancement

we have optimize create table using fast-create, but there are scenarios that we might create a lot of database, or run many DDLs like add/modify column in the maintenance window.
so we want to optimize execution of general DDL, and in a unified way

  • ddl: sync schema version using watch, notify sessions on owner node by job id #53217
  • add index on type for tidb_ddl_job to make some query faster
  • run lifecycle of a job in the worker, so we don't need to query them multiple times
  • move job dependency calculation into memory, to avoid the slower SQL
  • run general DDLs with multiple workers
  • notify the session which is not on DDL owner node when owner finished handling by RPC or other way
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant