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

TiDB OOM when SyncLoad statistics in the manytables scenario #53742

Closed
lilinghai opened this issue Jun 3, 2024 · 0 comments · Fixed by #53979
Closed

TiDB OOM when SyncLoad statistics in the manytables scenario #53742

lilinghai opened this issue Jun 3, 2024 · 0 comments · Fixed by #53979
Assignees
@hawkingrei
Labels
affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. feature/developing the related feature is in development impact/oom severity/major sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@lilinghai
Copy link
Contributor

lilinghai commented Jun 3, 2024 •
edited by ngaut
Loading

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

TiDB 16c 64GB

  1. prepare 700k tables and 5000 rows for each table
  2. analyze all tables
  3. query from tables currently

TiDB OOM for the statistics cache and sync load runtime mem consume
image

2. What did you expect to see? (Required)

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

master
@lilinghai lilinghai added the type/bug The issue is confirmed as a bug. label Jun 3, 2024
@hawkingrei hawkingrei self-assigned this Jun 3, 2024
@jebter jebter added sig/planner SIG: Planner severity/major feature/developing the related feature is in development impact/oom labels Jun 4, 2024
@hawkingrei hawkingrei mentioned this issue Jun 12, 2024
Merged
13 tasks
@hawkingrei hawkingrei added the affects-7.5 This bug affects the 7.5.x(LTS) versions. label Jun 12, 2024
ti-chi-bot bot pushed a commit that referenced this issue Jun 13, 2024
@hawkingrei
statistics: updating stats cache can trigger evict (#53979)
2ee6d22 
close #53742
This was referenced Jun 13, 2024
Merged
Merged
ti-chi-bot bot pushed a commit that referenced this issue Jun 25, 2024
@ti-chi-bot
statistics: updating stats cache can trigger evict (#53979) (#53991)
4a6f3e5 
close #53742
ti-chi-bot bot pushed a commit that referenced this issue Jun 25, 2024
@ti-chi-bot
statistics: updating stats cache can trigger evict (#53979) (#53992)
ef173c6 
close #53742
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@hawkingrei hawkingrei

Labels
affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. feature/developing the related feature is in development impact/oom severity/major 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: updating stats cache can trigger evict hawkingrei/tidb
3 participants
@hawkingrei @jebter @lilinghai