Web Interface slowly

[charlytux]

Hi all,

My Vicidial web interface is too slow & 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

[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)

[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

[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.

[charlytux]

Hi,
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!!

[williamconley]

What did you change it to?

[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.

[williamconley]

That much I got ... but what did you change it to? 200? 300?

[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

[mflorell]

Is your mysql server doing host lookups?

[DefLeppard]

Its not. I have the skip-name-resolve parameter in my.cnf

[mflorell]

I would suggest looking at your slow query log and running mtop and see if there are any clear slow queries happening.

[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.

[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?

[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>

[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.

[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

[williamconley]

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.