# MYSQL JDBC Connection properties
# http://dev.mysql.com/doc/refman/5.5/en/connector-j-reference-configuration-properties.html
jdbcCompliantTruncation=false
autoReconnect=false
zeroDateTimeBehavior=convertToNull

# disable unicode handling
useUnicode=false

# Get rid of SQL exceptions thrown in Mysql jdbc driver
holdResultsOpenOverStatementClose=true

# charset
#useUnicode=true
#characterEncoding=Cp1252

#dumpQueriesOnException=true

dontTrackOpenResources=true

#useCompression=true
#tcpRcvBuf=262144
#tcpSndBuf=262144

# setAutocommit / setIsolationLevel optimizations
useLocalSessionState=true
useLocalTransactionState=true
elideSetAutoCommits=true
alwaysSendSetIsolation=false
relaxAutoCommit=true

# metadata caching
cacheServerConfiguration=true
cacheResultSetMetadata=true
metadataCacheSize=100

# enable MySQL query cache - server prep stmts wont use caching
useServerPrepStmts=false

# prepared statement caching on JDBC client
cachePrepStmts=false
cacheCallableStmts=false
prepStmtCacheSize=4096
prepStmtCacheSqlLimit=32000

# log slow queries
#logSlowQueries=true
#slowQueryThresholdMillis=2000

noDatetimeStringSync=true
enableQueryTimeouts=false

traceProtocol=false
useUnbufferedInput=true
useReadAheadInput=true
maintainTimeStats=false

# timeouts for TCP/IP
connectTimeout=15000
socketTimeout=120000

# enable batch mode
rewriteBatchedStatements=true

# disable SSL
useSSL=false
