3.5.3.14 Debugging/Profiling

• logger

  The name of a class that implements "com.mysql.cj.log.Log" that will be used to log messages to. (default is "com.mysql.cj.log.StandardLogger", which logs to STDERR)

  Default Value	com.mysql.cj.log.StandardLogger
  Since Version	3.1.1

• profilerEventHandler

  Name of a class that implements the interface com.mysql.cj.log.ProfilerEventHandler that will be used to handle profiling/tracing events.

  Default Value	com.mysql.cj.log.LoggingProfilerEventHandler
  Since Version	5.1.6

• useNanosForElapsedTime

  For profiling/debugging functionality that measures elapsed time, should the driver try to use nanoseconds resolution if available (JDK >= 1.5)?

  Default Value	false
  Since Version	5.0.7

• maxQuerySizeToLog

  Controls the maximum length of the part of a query that will get logged when profiling or tracing

  Default Value	2048
  Since Version	3.1.3

• profileSQL

  Trace queries and their execution/fetch times to the configured 'profilerEventHandler'

  Default Value	false
  Since Version	3.1.0

• logSlowQueries

  Should queries that take longer than 'slowQueryThresholdMillis' or detected by the 'autoSlowLog' monitoring be reported to the registered 'profilerEventHandler'?

  Default Value	false
  Since Version	3.1.2

• slowQueryThresholdMillis

  If 'logSlowQueries' is enabled, how long should a query take (in ms) before it is logged as slow?

  Default Value	2000
  Since Version	3.1.2

• slowQueryThresholdNanos

  If 'logSlowQueries' is enabled, 'useNanosForElapsedTime' is set to true, and this property is set to a non-zero value, the driver will use this threshold (in nanosecond units) to determine if a query was slow.

  Default Value	0
  Since Version	5.0.7

• autoSlowLog

  Instead of using slowQueryThreshold* to determine if a query is slow enough to be logged, maintain statistics that allow the driver to determine queries that are outside the 99th percentile?

  Default Value	true
  Since Version	5.1.4

• explainSlowQueries

  If 'logSlowQueries' is enabled, should the driver automatically issue an 'EXPLAIN' on the server and send the results to the configured logger at a WARN level?

  Default Value	false
  Since Version	3.1.2

• gatherPerfMetrics

  Should the driver gather performance metrics, and report them via the configured logger every 'reportMetricsIntervalMillis' milliseconds?

  Default Value	false
  Since Version	3.1.2

• reportMetricsIntervalMillis

  If 'gatherPerfMetrics' is enabled, how often should they be logged (in ms)?

  Default Value	30000
  Since Version	3.1.2

• logXaCommands

  Should the driver log XA commands sent by MysqlXaConnection to the server, at the DEBUG level of logging?

  Default Value	false
  Since Version	5.0.5

• traceProtocol

  Should the network protocol be logged at the TRACE level?

  Default Value	false
  Since Version	3.1.2

• enablePacketDebug

  When enabled, a ring-buffer of 'packetDebugBufferSize' packets will be kept, and dumped when exceptions are thrown in key areas in the driver's code

  Default Value	false
  Since Version	3.1.3

• packetDebugBufferSize

  The maximum number of packets to retain when 'enablePacketDebug' is true

  Default Value	20
  Since Version	3.1.3

• useUsageAdvisor

  Should the driver issue 'usage' warnings advising proper and efficient usage of JDBC and MySQL Connector/J to the 'profilerEventHandler'?

  Default Value	false
  Since Version	3.1.1

• resultSetSizeThreshold

  If 'useUsageAdvisor' is true, how many rows should a result set contain before the driver warns that it is suspiciously large?

  Default Value	100
  Since Version	5.0.5

• autoGenerateTestcaseScript

  Should the driver dump the SQL it is executing, including server-side prepared statements to STDERR?

  Default Value	false
  Since Version	3.1.9