Our environment setup/config is below:
OS: CentOS 7.2.1511
Web server: Apache 2.4.6
DB server: Mysql CGE (NDB cluster 7.4.11)
RAM : 16 GB for each web and DB server.
CPU: 8 cores
About 200 users running processes at the peak time. We are noticing slow query especially from APP_CACHE_VIEW.
We have been thinking to deploy the DB in MySQl percona with XtraDB engine, but not sure whether that would be suitable for ProcessMaker to smoothly.
Appreciate some constructive feedback and recommendations/suggestions to overcome the slowness.
Thank you everyone.