日期:2014-05-16  浏览次数:20830 次

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 及以上

?