Category Archives: jdbc

MySQL Connector J and the curse of show variables

Yesterday I posted on the curse of the autocommit when using jdbc, but as sholmi commented you can also see a ton of “show variables”  statements as the connector J tries to figure what settings the database is using.   I … Continue reading

Posted in jdbc, mysql, performance, Uncategorized | 1 Comment

MySQL Connector J and the curse of Autocommit

In my travels I do a lot of analysis of the slow query and the general query logs. In many Java shops I end up seeing the most frequently called command is set autocommit=1; Sometimes this statement is called 300-400x … Continue reading

Posted in Common Mistakes, jdbc, Matt, mysql, performance | 3 Comments