You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@seatunnel.apache.org by "shannxisj (via GitHub)" <gi...@apache.org> on 2023/05/19 13:25:50 UTC
[GitHub] [incubator-seatunnel] shannxisj opened a new issue, #4789: Bug title [connector-jdbc] mysql to mysql slow,I added rewriteBatchStatements=true in the url, which did not solve it
shannxisj opened a new issue, #4789:
URL: https://github.com/apache/incubator-seatunnel/issues/4789
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-seatunnel/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues.
### What happened
I had the same problem, the version is the same as his, but I added rewriteBatchStatements=true in the url, which did not solve it
[issues_4658](https://github.com/apache/incubator-seatunnel/issues/4658)
### SeaTunnel Version
apache-seatunnel-incubating-2.3.1
### SeaTunnel Config
```conf
env {
job.mode = "BATCH",
execution.parallelism = 10
}
source {
Jdbc {
url = "jdbc:mysql://192.168.0.4:3307/sql?rewriteBatchStatements=true"
driver = "com.mysql.cj.jdbc.Driver"
user = "root"
password = "root"
query = "select * from test1"
}
}
sink {
Jdbc {
url = "jdbc:mysql://192.168.0.4:3307/sql?rewriteBatchStatements=true"
driver = "com.mysql.cj.jdbc.Driver"
user = "root"
password = "root"
query = "insert into test1_copy2(brand,stt,edt) values(?,?,?)"
}
}
```
### Running Command
```shell
Job Progress Information
seatunnel.sh --config env.config -e local
```
### Error Exception
```log
Job Id : 711925978242220033
Read Count So Far : 6048
Write Count So Far : 3999
Average Read Count : 100/s
Average Write Count : 66/s
Last Statistic Time : 2023-05-19 20:59:42
Current Statistic Time : 2023-05-19 21:00:42
***********************************************
Job Progress Information
***********************************************
Job Id : 711925978242220033
Read Count So Far : 9048
Write Count So Far : 6999
Average Read Count : 50/s
Average Write Count : 50/s
Last Statistic Time : 2023-05-19 21:00:42
Current Statistic Time : 2023-05-19 21:01:42
***********************************************
```
### Flink or Spark Version
_No response_
### Java or Scala Version
1.8
### Screenshots
_No response_
### Are you willing to submit PR?
- [X] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-seatunnel] shannxisj closed issue #4789: Bug title [connector-jdbc] mysql to mysql slow,I added rewriteBatchStatements=true in the url, which did not solve it
Posted by "shannxisj (via GitHub)" <gi...@apache.org>.
shannxisj closed issue #4789: Bug title [connector-jdbc] mysql to mysql slow,I added rewriteBatchStatements=true in the url, which did not solve it
URL: https://github.com/apache/incubator-seatunnel/issues/4789
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org