alibaba / alibaba/DataX

Mysql 数据导入 Replace 模式不能批量写入

Open
#524 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
17.4k
Forks
5.7k
PR merge metrics
No merged PRs in 30d

Description

数据库版本:阿里云分析型数据库mysql 3.0版
从数据库 A 将数据库导入到 数据库B时,wirtemodel设置为replace,执行过程中出现警告“CommonRdbmsWriter$Task - 回滚此次写入, 采用每次写入一行方式提交. 因为:[9001, 2019120211295017201624602903151682237] unsupport packet=>030000001B0100, packet_name=mysql_set_server_option”,导致写入速度超级慢。 该问题需要如何解决?

Contributor guide

No contributing guide indexed for this repository

Research direction

The report names no files, tests, or entry points. Reproduce a database A-to-B import against Alibaba Analytic Database MySQL 3.0 with writemodel set to replace, then investigate the unsupported mysql_set_server_option warning and verify that batch writes no longer fall back to one-row commits.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.