One of our bahmni implementations have lot of patient and obs data (around 3200000~ obs). Prod System requirements - 23GB, 12 core CPU. We have been facing performance issues for quite sometime. At least once in 45 days openmrs stops responding, restarting openmrs and mysql services used to solve the issue. We have faced this issue with bahmni 0.91. Recently we have upgraded bahmni from 0.91 to 0.92 and we started observing the same issue again. (Even with platform and http upgrade )
Similar issue has reported long back in the bahmni community and below is the JIRA card created in product backlog - https://bahmni.atlassian.net/browse/BAH-41
Below are the few points from JIRA card which applicable to our implementation too
- Peak times usually the load average touches 11 and CPU has 12 cores and users start complaining of extreme slowness
- The memory keeps increasing over a few days until restart
We started debugging issue. We are leveraging the Grafana graphs to analyse the issue. Meanwhile if somebody already noticed/tried to fix it, your points will be much helpful. Thanks !
@ajeenckya @arjun @mksrom @pramidat @ramashish @shivarachakonda @binduak @swetha184 @laxman @anandpatel @snehabagri @sushilp @sushmit @vmalini @akhilmalhotra @dipakthapa @ramashish@pradipta @mddubey @rrameshbtech @mddubey @iadksd @angshuonline @mwelazek @michaelbontyes @buvaneswariarun @praveenad @sanjayap @florianrappl @apaule @mwelazek @som.bhattacharyya @tejakancherla @rabbott @muhima08 @thomasrod @buvaneswariarun @swedhan @kirity @dkayiwa