Re: Why is useLocalSessionState false by default

[Todd Farmer]

Hi Florian,

What version of Connector/Java are you using? You might consider testing with the most recent version, if you are not already using it - I believe most calls you're trying to suppress have already been addressed.

That said, useLocalSessionState is disabled by default because it is safest to do so. People things like conn.createStatement().execute("SET auto_commit = OFF") instead of conn.setAutoCommit(false). Connector/Java doesn't parse every command to ensure local session state remains consistent, and relies on applications using standard JDBC API methods to track changes. That's not always a good assumption, but if it is for your use case, enabling useLocalSessionState can result in meaningful performance benefits.

Hope that helps!

--
Todd Farmer
MySQL @ Oracle
http://www.oracle.com/mysql/