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

Dump stats delta updates causes a lot of time when the number of changed tables is large #57737

Open
winoros opened this issue Nov 26, 2024 · 0 comments
Open

Dump stats delta updates causes a lot of time when the number of changed tables is large #57737

winoros opened this issue Nov 26, 2024 · 0 comments
Labels
sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.

Comments

@winoros
Copy link
Member

winoros commented Nov 26, 2024

Enhancement

Two kinds of SQL are used for the process.
Updating the count and modify_count in table mysql.stats_meta.
Image
Updating the total column size for the changed columns.
Image
Both of them are only updating one row per time. Causing that a lot of time wasted.
@winoros winoros added type/enhancement The issue or PR belongs to an enhancement. sig/planner SIG: Planner labels Nov 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@winoros