BuildAnalysisJobs using IterAllTables consumes too much memory in million tables

Open

#61,824 opened on Jun 19, 2025 0 comments 0 reactions 0 assignees View on GitHub

type/enhancement

Description

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

The 32GB specification TiDB instance owner will oom when init analysis jobs in the 8 million tables.

![Image](https://github.com/user-attachments/assets/60716847-8002-42bd-9044-7f4758623eb4)

![Image](https://github.com/user-attachments/assets/d3c4403b-305e-448d-9dec-781703cdb3a2)

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

### 3. What did you see instead (Required)

### 4. What is your TiDB version? (Required)
v8.5.2

This issue has not been assessed yet.