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

Query statistics lock is consuming excessive CPU resources during the auto-analysis check #49472

Closed
Rustin170506 opened this issue Dec 14, 2023 · 2 comments · Fixed by #49473
Closed

Query statistics lock is consuming excessive CPU resources during the auto-analysis check #49472

Rustin170506 opened this issue Dec 14, 2023 · 2 comments · Fixed by #49473
Labels
affects-7.5 This bug affects the 7.5.x(LTS) versions. report/customer Customers have encountered this bug. severity/moderate sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@Rustin170506
Copy link
Member

Enhancement

If you have a large number of tables, the auto-analyze worker can help you analyze them efficiently by checking if they need to be analyzed. However, during the analysis, we need to obtain the stats lock information. If a table is already locked, then there is no need to analyze it.
If your table is small, it needs to be checked frequently which can lead to excessive CPU resource consumption due to the querying of statistics lock.

img_v3_0062_98257775-ab90-4ea8-bbf9-64252d65b53g
@Rustin170506 Rustin170506 added the type/enhancement The issue or PR belongs to an enhancement. label Dec 14, 2023
@Rustin170506 Rustin170506 mentioned this issue Dec 14, 2023
Merged
13 tasks
@Rustin170506 Rustin170506 added type/bug The issue is confirmed as a bug. sig/planner SIG: Planner severity/moderate affects-7.5 This bug affects the 7.5.x(LTS) versions. and removed type/enhancement The issue or PR belongs to an enhancement. labels Dec 18, 2023
ti-chi-bot bot pushed a commit that referenced this issue Dec 18, 2023
@Rustin170506
statistics: only query locks once (#49473)
23953a7 
close #49472
@ti-chi-bot ti-chi-bot mentioned this issue Dec 18, 2023
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jan 25, 2024
@ti-chi-bot
statistics: only query locks once (#49473) (#49554)
e90e302 
close #49472
@seiya-annie
Copy link

/found customer

1 similar comment
@seiya-annie
Copy link

/found customer

@ti-chi-bot ti-chi-bot bot added the report/customer Customers have encountered this bug. label Jun 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
affects-7.5 This bug affects the 7.5.x(LTS) versions. report/customer Customers have encountered this bug. severity/moderate sig/planner SIG: Planner type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

statistics: only query locks once Rustin170506/tidb
2 participants
@Rustin170506 @seiya-annie