- Tue Oct 31, 2017 1:53 am
#796011
We have been experiencing slowness in terms of running default built-in ProcessMaker quires.
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.
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.