Mysql 数据导入 Replace 模式不能批量写入
Open
- 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