Processmaker 3.0.1.7-community Mysql Database slow

Ask questions about your install or get help installing and configuring ProcessMaker 2

Moderator: amosbatto

jalisadm
Posts: 1
Joined: Mon Sep 21, 2015 1:03 am
Country: Malaysia

Processmaker 3.0.1.7-community Mysql Database slow

Unread postby jalisadm » Tue Oct 31, 2017 1:53 am

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.

amosbatto
Posts: 5441
Joined: Mon Jun 22, 2009 10:28 am
Country: Bolivia
Location: La Paz

Re: Processmaker 3.0.1.7-community Mysql Database slow

Unread postby amosbatto » Tue Oct 31, 2017 9:52 pm

When the web server is slow, is all the RAM being used? 16GB is probably too little for the web server with 200 concurrent users. What percentage of your CPU is being used with 8 cores?

Another thing you can do is install multiple web servers. Here is the basic idea:
http://iws.io/multiple-web-servers-over-a-single-ip-using-apache-as-a-reverse-proxy/

The Enterprise version is optimized for faster display of case lists and for large numbers of cases. You should call/email ProcessMaker Sales and ask for a trial license to see if using the Enterprise version will speed up your installation.
Amos B. Batto ♦ ProcessMaker Technical Documentation Writer & Forum Manager ♦ Cofounder of ILLA (http://www.illa-a.org)

amosbatto
Posts: 5441
Joined: Mon Jun 22, 2009 10:28 am
Country: Bolivia
Location: La Paz

Re: Processmaker 3.0.1.7-community Mysql Database slow

Unread postby amosbatto » Tue Oct 31, 2017 9:57 pm

I don't think that anyone here at ProcessMaker, Inc. has tested the XtraDB engine, but I don't talk much to the Dev team. If you test it, please let us know the results of your tests.
Amos B. Batto ♦ ProcessMaker Technical Documentation Writer & Forum Manager ♦ Cofounder of ILLA (http://www.illa-a.org)


Return to “Installation & Configuration”

Who is online

Users browsing this forum: Google [Bot] and 2 guests