Re: MySQL Connector/J 5.0.3 Has Been Released
Mark Matthews <[email protected]>
| Newsgroups | gmane.comp.db.mysql.java |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Kevin Burton wrote: >> .MySQL Connector/J 5.0.3 a new version of the Type-IV all-Java JDBC >> driver for MySQL has been released. > > I didn't see any documentation for this so I just figure I'll ask. > > What performance advantages are there to migrate from 3.1.10 to 5.0.3 ? > > Specifically Java related... Kevin, Specific to Java, the synchronization has been loosened up quite a bit (with careful analysis, so no, it's not dangerous), to prevent deadlocks when using pool managers such as C3P0. We also removed a static synchronization bottleneck when using multibyte character sets, which showed up under high load. 5.0 also contains the performance feature that will rewrite [Prepared]Statement.executeBatch() into either multi-valued inserts or batched statements to save round-trips, by adding "rewriteBatchedStatements=true" to your JDBC URL configuration. > > We're still on 3.1.0 with MySQL 4.1 because its REALLY stable... there > isn't as much in the 5.0 series to encourage a migration right now but > the partitioning in 5.1 might be something worth migrating too... > we'll see... > > Kevin > Yes, partitioning is an interesting feature for a lot of folks that have large data sets that need to get pruned by age, and such. -Mark -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEyiPrtvXNTca6JD8RAp0KAKCTCAsznPT6ycdI79Mr5ibP42L+fACfUri/ LazL/Gpk/65VZoAhVuYbwuQ= =MZki -----END PGP SIGNATURE----- -- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe: http://lists.mysql.com/[email protected]