[DM][Index] DM is very slow during the load phase. Can data be imported first and then indexes created?

Translated
1

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

Original topic: 【DM】【索引】dm在load阶段很慢。能否先导入数据，再创建索引

| username: fluent

[TiDB Usage Environment] Production Environment
[TiDB Version] v6.5.0
[Reproduction Path] Using DM tool to synchronize data
[Encountered Problem: Problem Phenomenon and Impact]
Due to the use of the lightning SQL mode for data import by DM, when there are too many indexes on the table, importing data using SQL mode becomes very slow.
Can the table indexes be created after the full import is completed, and then perform incremental synchronization to improve import efficiency?
[Resource Configuration]
[Attachment: Screenshot/Log/Monitoring]

2
| username: lance6716 | Original post link

You can create the table in advance downstream.

3
| username: WalterWj | Original post link

No, creating an index in TiDB is done in a serial manner. It’s better to create it in advance.

4
| username: fluent | Original post link

After creating them in advance, will the database and tables not be automatically created during the DM migration?

5
| username: tidb菜鸟一只 | Original post link

Create a table without indexes in advance, then migrate through DM. After the migration is complete, create the indexes.

6
| username: system | Original post link

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