Java mysql batch 提速 "rewriteBatchedStatements=true"

Mysql jdbc 批处理数据，需要给jdbc连接加上rewriteBatchedStatements=true。默认jdbc是不会开启批处理。

例如：jdbc:mysql://10.250.4.98:3306/dbname?rewriteBatchedStatements=true

 

Java UpdateBatchSample：

http://www.java2s.com/Code/Java/Database-SQL-JDBC/BatchupdateforMySQL.htm

 

官网forums

http://forums.mysql.com/read.php?39,260053,263456#msg-263456

MySQL itself has no real "batch" API for prepared statements. If you add the configuration property "rewriteBatchedStatements=true" to your JDBC connection string for Connector/J, the driver will rewrite batches of prepared INSERTs into multi-value form, and all other forms of statements into multi-statements, which does give a large performance gain (7-10x). 

 

注意：

jdbc driver 版本需要 5.1.8 及以上

 

评论

1 楼 xunke515 2013-02-04  

学习了～感谢分享