Page 1 of 1

Web Interface slowly

PostPosted: Mon Jun 24, 2013 7:42 pm
by charlytux
Hi all,

My Vicidial web interface is too slow & :shock: suddenly i'm unable to see real time report (takes 2~4 min to render), I have, 45~65 agents logged in, 1 Server | 4 Inbound DID's | 4 campaigns

Thank's

Re: Web Interface slowly

PostPosted: Mon Jun 24, 2013 7:56 pm
by williamconley
Look at your server load. You may have exceeded your mysql capacity on a single server system after bloating your logs for a while.

Prune your log tables (there is a script to archive them in crontab -e)

Re: Web Interface slowly

PostPosted: Tue Jun 25, 2013 10:28 am
by charlytux
Thanks for reply.

Here my sys Stats:
load average: 0.12, 0.32, 0.32
Tasks: 265 total, 1 running, 264 sleeping, 0 stopped, 0 zombie
Cpu(s): 6.7%us, 2.2%sy, 0.0%ni, 90.7%id, 0.0%wa, 0.0%hi, 0.4%si, 0.0%st
Mem: 11847M total, 1212M used, 10634M free, 7M buffers
Swap: 4071M total, 0M used, 4071M free, 698M cached

also i have a lot of this:

wwwrun 20 0 59848 11m 6640 S 0 0.1 0:05.43 httpd2-prefork

Re: Web Interface slowly

PostPosted: Tue Jun 25, 2013 11:36 pm
by gardo
Check your server load when you are running in production (i.e., when your agents are taking calls). The stats you posted looks like a server in idle mode.

Re: Web Interface slowly

PostPosted: Fri Jun 28, 2013 2:38 pm
by charlytux
Hi,
:D Apparently the solution was in the apache,
changed the parameter "MaxClients" in /etc/apache2/server-tuning.conf,
restarted apache and left to hang interface...

Thanx!!

Re: Web Interface slowly

PostPosted: Fri Jun 28, 2013 3:05 pm
by williamconley
What did you change it to?

Re: Web Interface slowly

PostPosted: Fri Jun 28, 2013 3:36 pm
by charlytux
Hi William,
When the interface freezes apache sends this message, "reached MaxClients setting, consider raising the MaxClients setting" so i increased the MaxClients param spending a little more RAM for apache-prefork.

Re: Web Interface slowly

PostPosted: Fri Jun 28, 2013 4:03 pm
by williamconley
That much I got ... but what did you change it to? 200? 300?

Re: Web Interface slowly

PostPosted: Tue May 20, 2014 2:03 pm
by DefLeppard
Hello,

I am having this same issue. I increased the MaxClients parameter to 300 but nothing changed. There are 35 agents logged in but most campaigns on this dialer are manual or inbound. The server is placing just 30-40 calls at any given time. Config is Supermicro Dual Xeon 5420, 8GB RAM. Loag avg is 0.77 and CPU usage is less than 10%.
VERSION: 2.8-431a
BUILD: 140314-1134

Re: Web Interface slowly

PostPosted: Tue May 20, 2014 7:45 pm
by mflorell
Is your mysql server doing host lookups?

Re: Web Interface slowly

PostPosted: Tue May 20, 2014 8:48 pm
by DefLeppard
Its not. I have the skip-name-resolve parameter in my.cnf

Re: Web Interface slowly

PostPosted: Tue May 20, 2014 10:34 pm
by mflorell
I would suggest looking at your slow query log and running mtop and see if there are any clear slow queries happening.

Re: Web Interface slowly

PostPosted: Thu May 22, 2014 12:23 pm
by DefLeppard
I was able to resolve this. I updated the crontab entry for the Vicidial hopper update script to run every 3 minutes instead of every minute.

Re: Web Interface slowly

PostPosted: Mon Feb 22, 2016 6:38 am
by ZibiX
Hi.

I have recently added 2 asterisk servers to a cluster.

Now I have:
1 x DB/WEB
3 x ASTERISK

All are 6.0.3 Vicibix SVN: 2368
Asterisk 1.8

All serwera are: Xeon 3.1 GHz, 8 GB RAM, SSD

To the moment that I have added 2 new dialers system (1 x DB/WEb and 1 x ASTERISK) was running fine.

When I have added 2 new dialers I have been experiencing Web interface lookup. On admin site i have to wait few second do access admin site. On the agent site tthere a lot of Your session have been paused or There are no one in your session.

Load avg of DB WEB when this is happening are 0.98, 0.98, 1.01

50-60 agents are using this cluster with ratio on 4.

In apache log there are no errors. In mysql log (i believe it is in /var/log/messages) there are no errors.

What can i else check?

Re: Web Interface slowly

PostPosted: Mon Feb 22, 2016 1:31 pm
by williamconley
Code: Select all
nano /etc/apache2/server-tuning.conf

Modify the "prefork" section:
Code: Select all
# prefork MPM
<IfModule prefork.c>
        # number of server processes to start
        # http://httpd.apache.org/docs/2.2/mod/mpm_common.html#startservers
        StartServers         450
        # minimum number of server processes which are kept spare
        # http://httpd.apache.org/docs/2.2/mod/prefork.html#minspareservers
        MinSpareServers      250
        # maximum number of server processes which are kept spare
        # http://httpd.apache.org/docs/2.2/mod/prefork.html#maxspareservers
        MaxSpareServers     500
        # highest possible MaxClients setting for the lifetime of the Apache process.
        # http://httpd.apache.org/docs/2.2/mod/mpm_common.html#serverlimit
        ServerLimit        768
        # maximum number of server processes allowed to start
        # http://httpd.apache.org/docs/2.2/mod/mpm_common.html#maxclients
        MaxClients         768
        # maximum number of requests a server process serves
        # http://httpd.apache.org/docs/2.2/mod/mpm_common.html#maxrequestsperchild
        MaxRequestsPerChild  1000
</IfModule>

# worker MPM
<IfModule worker.c>
        # initial number of server processes to start
        # http://httpd.apache.org/docs/2.2/mod/mpm_common.html#startservers
        StartServers         25
        # minimum number of worker threads which are kept spare
        # http://httpd.apache.org/docs/2.2/mod/mpm_common.html#minsparethreads
        MinSpareThreads     50
        # maximum number of worker threads which are kept spare
        # http://httpd.apache.org/docs/2.2/mod/mpm_common.html#maxsparethreads
        MaxSpareThreads     300
        # upper limit on the configurable number of threads per child process
        # http://httpd.apache.org/docs/2.2/mod/mpm_common.html#threadlimit
        ThreadLimit         64
        # maximum number of simultaneous client connections
        # http://httpd.apache.org/docs/2.2/mod/mpm_common.html#maxclients
        MaxClients         500
        # number of worker threads created by each child process
        # http://httpd.apache.org/docs/2.2/mod/mpm_common.html#threadsperchild
        ThreadsPerChild     50
        # maximum number of requests a server process serves
        # http://httpd.apache.org/docs/2.2/mod/mpm_common.html#maxrequestsperchild
        MaxRequestsPerChild  50000
</IfModule>

Re: Web Interface slowly

PostPosted: Mon Feb 22, 2016 5:13 pm
by ZibiX
Thanks.

I have found the same solution here: http://www.eflo.net/VICIDIALforum/viewt ... 078#p99495

I will let you know if this was the issue.

Re: Web Interface slowly

PostPosted: Tue Feb 23, 2016 6:35 am
by ZibiX
Confirmed. Solution with changing values in prefork section of /etc/apache2/server-tuning.conf works.

Also I recommend enabling server-status module to watch apache utilization in real time.
Hot to enable? -> http://serverfault.com/questions/357122 ... erprise-11

Re: Web Interface slowly

PostPosted: Tue Feb 23, 2016 10:17 am
by williamconley
ZibiX wrote:Confirmed. Solution with changing values in prefork section of /etc/apache2/server-tuning.conf works.

Also I recommend enabling server-status module to watch apache utilization in real time.
Hot to enable? -> http://serverfault.com/questions/357122 ... erprise-11

Excellent Postback. 8-)