MYSQL performance options

[flefoll]

Dear all,

We are looking for a performance trick?
Today we are using Alfresco with MySQL, knowning MySQL DB string is :
db.url=jdbc:mysql://localhost:3306/alfresco41?useUnicode=true&characterEncoding=UTF-8

We are considering to use such supplementary argues too :
autoReconnect=true
allowMultiQueries=true
cacheCallableStmts=true
cachePrepStmts=true
cacheResultSetMetadata=true
cacheServerConfiguration=true

Objective is to enhance performances… (and autoReconnect)

Does somebody have some bench, some advices ?

Thanks by advance,
Best regards,

Francois

[derek]

Hi,
You can do the reconnection there, or you can activate the custom-connection-pool-context.xml.sample. 
Regards