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

concurrency auto analyze #53460

Closed
hawkingrei opened this issue May 22, 2024 · 0 comments · Fixed by #54432 or #56226
Closed

concurrency auto analyze #53460

hawkingrei opened this issue May 22, 2024 · 0 comments · Fixed by #54432 or #56226
Labels
type/enhancement The issue or PR belongs to an enhancement.

Comments

@hawkingrei
Copy link
Member

Enhancement

Now, TiDB's analyze can only be executed by a single goroutine. so when we use millions of tables, it will be very slow, so we need to implement the concurrently auto analyze for raising the QPS of auto analyze.
@hawkingrei hawkingrei added the type/enhancement The issue or PR belongs to an enhancement. label May 22, 2024
This was referenced May 22, 2024
Open
Closed
@hawkingrei hawkingrei mentioned this issue Jul 25, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jul 29, 2024
@hawkingrei
*: remove limiting process id for auto analyze (#54902)
273ca66 
ref #53460
hawkingrei added a commit to hawkingrei/tidb that referenced this issue Aug 1, 2024
@hawkingrei
*: remove limiting process id for auto analyze (pingcap#54902)
4e7c007 
ref pingcap#53460
@hawkingrei hawkingrei mentioned this issue Aug 15, 2024
Merged
13 tasks
@ti-chi-bot ti-chi-bot bot closed this as completed in f272707 Aug 16, 2024
@Rustin170506 Rustin170506 reopened this Aug 19, 2024
@Rustin170506 Rustin170506 mentioned this issue Aug 19, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Aug 22, 2024
@Rustin170506
statistics: fix a data race in auto-analyze (#55501)
e72089d 
ref #53460
@hawkingrei hawkingrei mentioned this issue Sep 23, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Sep 24, 2024
@hawkingrei
variable: set default tidb_auto_analyze_concurrency as 1 (#56226)
e87affb 
close #53460
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
2 participants
@hawkingrei @Rustin170506