AnsweredAssumed Answered

Alfresco 4.0 community, Solr and mysql performance problems

Question asked by edrusiani on Jul 15, 2014
Hi

i'm having some trouble with my Alfresco/solr/mysql configuration.

On startup, Alfresco does a huge amount of SELECT on Mysql, degrading performance in just 10 minutes, without any user activity. checking with mysqlreport i've found that solr makes alfresco doing 600/800k queries in just 10 minutes

i've tried tweaking config file, like

/tomcat/shared/classes/alfresco-global.properties index.recovery.mode=NONE
/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/model/contentModel.xml setting indexing to false

and even

/usr/local/alfresco/alf_data/solr/workspace-SpacesStore/conf/solrconfig.xml
/usr/local/alfresco/alf_data/solr/workspace-SpacesStore/conf/solrcore.properties

setting

alfresco.cron=0/600 * * * * ? *
alfresco.batch.count=2000
<ramBufferSizeMB>256</ramBufferSizeMB>
<mergeFactor>25</mergeFactor>

but with no luck at all.

any suggestion?

thanks for your time and your help

Outcomes