The migration/sync task takes too long or gets stuck.
Note:If you select Full + Incremental migration as the migration type, after the full migration task is completed, the incremental migration task will continue, and you need to manually stop it by clicking Done in the Operation column; otherwise, the task will keep running, which is not the case of a stuck task.
The data volume is high, slowing down the migration/sync task.
Check whether the source database has a slow SQL statement; if so, process the statement; if not, check other causes.
The content in the source database is non-compliant. For example, if the source database has tables without a primary key, large queries involving such tables will slow down the task. We recommend you add a primary key to such tables or not migrate them.
In incremental migration or sync, if no data is written to the source database for a long time or there is an empty binlog, you can write data to the source database to resume the task.
Was this page helpful?