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

GCStats runs too many times #31778

Closed
XuHuaiyu opened this issue Jan 18, 2022 · 1 comment · Fixed by #46138
Closed

GCStats runs too many times #31778

XuHuaiyu opened this issue Jan 18, 2022 · 1 comment · Fixed by #46138
Labels
report/customer Customers have encountered this bug. sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.

Comments

@XuHuaiyu
Copy link
Contributor

Enhancement

There are ~4000 tables in tidb-server, and only 78 of them are frequently accessed.

From the dashboard we can see that the SQLs triggered by GCStats run too frequently.
截屏2022-01-18 下午9 22 22

Which causes the CPU to oscillate every 5mins:
截屏2022-01-18 下午9 24 21
@XuHuaiyu XuHuaiyu added type/enhancement The issue or PR belongs to an enhancement. sig/planner SIG: Planner labels Jan 18, 2022
@winoros
Copy link
Member

winoros commented Aug 10, 2023

ref #45966

@winoros winoros mentioned this issue Aug 16, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Sep 11, 2023
@winoros
statistics: record last gc ts to avoid huge read on stats table (#46138)
51f1a82 
close #31778, close #45966
@seiya-annie seiya-annie added the report/customer Customers have encountered this bug. label Jul 29, 2024
@ti-chi-bot ti-chi-bot mentioned this issue Aug 13, 2024
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Aug 25, 2024
@ti-chi-bot
statistics: record last gc ts to avoid huge read on stats table (#46138…
d36d14a 
…) (#55381)

close #31778, close #45966
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
report/customer Customers have encountered this bug. sig/planner SIG: Planner 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.

statistics: record last gc ts to avoid huge read on stats table winoros/tidb
3 participants
@winoros @XuHuaiyu @seiya-annie