Connector/J Performance Gems

Connector/J has nearly 200 configuration options. Many of them affect performance. While the options are documented, many aren’t shown alongside the use cases they apply to. Out of the box, Connector/J is configured with the principle of least surprise, and is JDBC-compliant, and provides a pretty genericized view of MySQL.

In this session, the author of Connector/J will show attendees how to wring that last little bit of performance out of their Java applications deployed on MySQL by not using the out-of-the-box configuration. Topics covered will include:

• Load balancing and load splitting
• Bulk data loading
• Automatic Batch DML rewriting
• Configurations that approach the edge of safety, but that are useful for those few % points of performance