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

Optimize reorganize partition backfill data copying #60381

Open
mjonss opened this issue Apr 2, 2025 · 0 comments · May be fixed by #60382
Open

Optimize reorganize partition backfill data copying #60381

mjonss opened this issue Apr 2, 2025 · 0 comments · May be fixed by #60382
Assignees
@mjonss
Labels
type/enhancement The issue or PR belongs to an enhancement.

Comments

@mjonss
Copy link
Contributor

mjonss commented Apr 2, 2025

Enhancement

In #60132 to be fully consistent we check all rows in the new reorganized partition by reading them before writing them, to avoid overwriting concurrent DMLs (insert/update), but it should be possible to optimize the optimistic path, by trying to write and fail if the key already exists, by using the PresumeKeyNotExists.
@mjonss mjonss added the type/enhancement The issue or PR belongs to an enhancement. label Apr 2, 2025
@mjonss mjonss self-assigned this Apr 2, 2025
@mjonss mjonss linked a pull request Apr 2, 2025 that will close this issue
Open
13 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@mjonss mjonss

Labels
type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

ddl: Non clustered reorg part optimistic backfill mjonss/tidb
1 participant
@mjonss