| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263 |
- # 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
|
