n o t e 1 9 . c o m

On the Mac, there is an application called Java Preferences. You can use the Spotlight to find it. Launch the Java Preferences and in the Java Application Runtime Settings panel, drag the version of the JDK that you wish to use to the top. Save and restart any terminal applications that you may have had opened and you should be set.

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.

Here are the Java JVM options to enable remote debugging:

-Xdebug -Xnoagent -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=8000