The issue of slow data insertion in TiDB

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

Original topic: tidb插入数据慢的问题

| username: TiDBer_FMWXa7ja

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version]
[Reproduction Path]
[Encountered Problem: Problem Phenomenon and Impact] With three TiDB storage nodes, after inserting 40 million rows into a table, the insertion speed becomes very slow, with only a dozen rows inserted per second. Given sufficient disk space on the three nodes, how large can a single table grow? What are the solutions for slow insertion?
[Resource Configuration]
[Attachments: Screenshots / Logs / Monitoring]

| username: Kongdom | Original post link

You can refer to this for troubleshooting:

| username: 会飞的土拨鼠 | Original post link

Data write is relatively slow, it might be related to disk IO. Is the disk an SSD or a mechanical hard drive?

| username: 考试没答案 | Original post link

Please share your cluster configuration. My single table data volume exceeds 100 million, with a maximum of 2 billion, and it can still be stored successfully.

| username: 考试没答案 | Original post link

Please also describe your method of data insertion. The more detailed, the better.

| username: zhouzeru | Original post link

I use replace into