Unsubscribe from updates to this bug at:https://bugs.mysql.com/77681 Updated by:daniel che Chung so reported by:oca Ad Min category:connector/j severity:s3 (non-critical)-status:in progress+status:closed version:5.1. x os:any[20 23:25] Daniel che Chung soadded The following entry to the connector/j 5.1.37 changelog: "The Cod E for executing a REPLACE statement whenrewritebatchedstatements=true have been refactored by putting multiplebatched state ments into a single query, making it work more like Aninsert statement. This increases the efficiency for running replacestatements. Thanks to Jie Han for contributing the patch. " ------------------------------------------------------------------------[Jul 9:17] Jie hanwe have billions records Transfer from offline to online, rewritereplace statement would save lots of bytes. and Rewirte to one SQL Meansdon ' t need explicitly begin TRANSACTION, because one SQL would executein a standalone TRANSAC tion wheN autocommit is true,this save tworequest for every batch. The Where network is slow autocommit would save moretime. Hope rewrite replace statement would release in next Version.------------------------------------------------------------------------[Jul 17:27] Filipe silvabug# 40561 is a duplicate of this.------------------------------------------------------------------------[8:00] Umesh umeshhello! Thank the report and contribution. Thanks,umesh
Optimized for Java driver submission to MySQL the next release is ^_^