n o t e 1 9 . c o m

Every once in while I need to log slow queries using the JDBC logging parameters and it always takes me a while to find this information. So here it is (line breaks for readability):

?profileSQL=true&
slowQueryThresholdMillis=100&
autoSlowLog=true&
explainSlowQueries=true&
gatherPrefMetrics=true&
logSlowQueries=true

Simply add the above parameters to your JDBC connection string.

This entry was posted on February 16, 2008 at 9:54 pm and is filed under Java, MySql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.