TiDB Server Out of Memory (OOM)

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidb server OOM

| username: nuanhuang

Question: Exporting data using mydumper and importing it into TiDB, the server node’s memory keeps increasing until it OOMs.
Version: 4.0.16
TiDB Server monitoring graph:

image
image1380×356 31.3 KB

2
| username: xfworld | Original post link

Batch import…

3
| username: nuanhuang | Original post link

I have already imported it serially by table. How should I batch it?

4
| username: xfworld | Original post link

Batching transactions, a super large transaction will definitely lead to OOM…

5
| username: nuanhuang | Original post link

An insert statement only has 3K rows of data now. :joy:

6
| username: xfworld | Original post link

Is each insert executed and committed one by one, or are N inserts executed and then committed?

7
| username: alfred | Original post link

Is it possible to limit memory usage?

8
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.