Slow performance

[racosta79]

We have an installation with the following configuration:

1 DB Server Dell PowerEdge R720
2 Web Server HP ML110 16GB RAM
6 Telephony Server Xeon Quad 4 GB RAM
1 Archive Server HP ML110 16GB RAM

140 Agents all Inbound, PoE phones
6 SIP trunks

Now we are having slow performance, tri-way calls and muted calls when heavy load is received (300 calls).

When this happens we need to stop Asterisk, then restart MySQL service as well.

I don't know what to do.

I will appreciate your help people.!

[williamconley]

1) Welcome to the Party!

2) As you are obviously new here, I have some suggestions to help us all help you:

When you post, please post your entire configuration including (but not limited to) your installation method and vicidial version with build.

This IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "from scratch" you must post your operating system and should also post the .iso version from which you installed your original operating system. If your installation is "Hosted" list the site name of the host.

If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

3) If you have 150 users and have not taken the Vicidial course in Clearwater, you should seriously consider it. There are several enhancements and fixes that may be required to get your system stable, but knowing only how many servers you have is not likely to get us there. LOL

4) run "htop" on each machine during an occurrence and look for overload.

5) Look also for slow queries in the mysql server. Look also at any customizations you may have that could be requesting mysql information and locking tables. Also consider some of the recent posts regarding mysql overload from too many connections, there has been some progress on that front for heavily used servers with some slight adjustments (if mysql turns out to be an issue).

6) Happy Hunting!

[racosta79]

Hello William, thank you for your reply.

1) Thank you... again.
2) Vicibox 4.0.3 from .iso | Vicidial 2.6-393a Build 130124-1721 | Asterisk 1.4.44-vici | Multi Server | No Digium/Sangoma Hardware | No Extra Software After Installation | 1 DB Server Dell PowerEdge R720 Xeon E5-2650 32GB RAM | 2 Web Server HP ML110 Xeon X3430 16GB RAM | 6 Telephony Server i3-2120 4 GB RAM | 1 Archive Server HP ML110 X3430 16GB RAM
3) I know I have to take the course
4) htop is to "basic", I had done it in all servers during the occurrence, but nothing increase more than 30% CPU usage, 40% Memory usage, no overload...
5) MySQL keeps those queries related to open channels in my Asterisk Servers. Sorry I forgot to mention that when this occur, I have lot of open sessions in BYE states in my Asterisks
Maybe my VoIP trunk provider is not closing properly the channels, but they say that there is no problem with their service and I cant also go and audit it
6) I am not happy

Regards...

[williamconley]

consider an upgrade. 2.6 is fairly old and wasn't all that stable (very few users on that version, as a matter of fact) and you may find that later code will help resolve some issues.

explain "a lot of open sessions in BYE states". Show output.

explain "MySQL keeps those queries related to open channels in my Asterisk Servers". Show output.

by 30% CPU usage, you mean average server load 1.2 on a 4 processor system or 2.6 on an 8 processor system?