-
Recent Posts
Recent Comments
- Harrison on Helping to Organize a MySQL Bootcamp @ IOUG’s COLLABORATE 11
- Mark Callaghan on More Debate, More Flame, More Choosing the correct tool for the job
- Matthew Yonkovit on New Benchmark I am working on that tests MYSQL -vs- NOSQL
- Sam on New Benchmark I am working on that tests MYSQL -vs- NOSQL
- Matt Montgomery on New Benchmark I am working on that tests MYSQL -vs- NOSQL
Archives
- October 2011
- May 2011
- October 2010
- September 2010
- April 2010
- March 2010
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- August 2008
- July 2008
- June 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
Categories
Meta
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