Skip to content
This repository has been archived by the owner on Nov 24, 2023. It is now read-only.

Check all generated DML will get PointGetPlan #1851

Open
lance6716 opened this issue Jul 9, 2021 · 1 comment
Open

Check all generated DML will get PointGetPlan #1851

lance6716 opened this issue Jul 9, 2021 · 1 comment
Labels
type/feature-request This issue is a feature request

Comments

@lance6716
Copy link
Collaborator

lance6716 commented Jul 9, 2021 •
edited

Feature Request

Is your feature request related to a problem? Please describe:

sometimes downstream has changed table structure, and DM may silently assigned wrong plan, which may cause duration arise and TiDB CPU consumption arise

Describe the feature you'd like:

precheck the plan. If WHERE clause can cover PK/UK columns PointGet will be chosen. 🤔

fire a warning in alert manager.

Describe alternatives you've considered:

Teachability, Documentation, Adoption, Migration Strategy:
@lance6716
Copy link
Collaborator Author

cc @lysu

@lance6716 lance6716 added the type/feature-request This issue is a feature request label Jul 19, 2021
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
type/feature-request This issue is a feature request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@lance6716