[GitHub] [incubator-shardingsphere] lklkxcxc edited a comment on issue #4231: mysqldump file import sharding-proxy insert speed slowly
lklkxcxc edited a comment on issue #4231: mysqldump file import sharding-proxy insert speed slowly URL: https://github.com/apache/incubator-shardingsphere/issues/4231#issuecomment-584619277 @kimmking Can you give me a specific example? thank you!It isnot that how use parm `useServerPrepStmts=true=true`? I found add prarm `rewriteBatchedStatements=true` can to improve speed but still not very fast 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. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-shardingsphere] lklkxcxc edited a comment on issue #4231: mysqldump file import sharding-proxy insert speed slowly
lklkxcxc edited a comment on issue #4231: mysqldump file import sharding-proxy insert speed slowly URL: https://github.com/apache/incubator-shardingsphere/issues/4231#issuecomment-584619277 @kimmking Can you give me a specific example? thank you!It isnot that how use parm `useServerPrepStmts=true=true`? @terrymanu I found add prarm `rewriteBatchedStatements=true` can to improve speed but still not very fast 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. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-shardingsphere] lklkxcxc edited a comment on issue #4231: mysqldump file import sharding-proxy insert speed slowly
lklkxcxc edited a comment on issue #4231: mysqldump file import sharding-proxy insert speed slowly URL: https://github.com/apache/incubator-shardingsphere/issues/4231#issuecomment-584619277 @kimmking Can you give me a specific example? thank you!It isnot that how use parm `useServerPrepStmts=true=true`? 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. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-shardingsphere] lklkxcxc edited a comment on issue #4231: mysqldump file import sharding-proxy insert speed slowly
lklkxcxc edited a comment on issue #4231: mysqldump file import sharding-proxy insert speed slowly URL: https://github.com/apache/incubator-shardingsphere/issues/4231#issuecomment-584493358 @terrymanu There is not much change ,I have used param:`serverTimezone=UTC=false=utf8=true=true` The test is faster to import directly into backend mysql database; 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. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-shardingsphere] lklkxcxc edited a comment on issue #4231: mysqldump file import sharding-proxy insert speed slowly
lklkxcxc edited a comment on issue #4231: mysqldump file import sharding-proxy insert speed slowly URL: https://github.com/apache/incubator-shardingsphere/issues/4231#issuecomment-584484024 @terrymanu : I didn't used PreparedStatement and ParameterMarker. What are PreparedStatement and ParameterMarker? database0?serverTimezone=UTC=false=utf8 use sql `insert into pku_influencing_factor VALUES (0,'test','test',123.00)` normal only 1 record 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. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services
[GitHub] [incubator-shardingsphere] lklkxcxc edited a comment on issue #4231: mysqldump file import sharding-proxy insert speed slowly
lklkxcxc edited a comment on issue #4231: mysqldump file import sharding-proxy insert speed slowly URL: https://github.com/apache/incubator-shardingsphere/issues/4231#issuecomment-584484024 @terrymanu : I didn't used PreparedStatement and ParameterMarker. What are PreparedStatement and ParameterMarker? database0?serverTimezone=UTC=false=utf8 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. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services