Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-11-06 Thread das sandesh
Thanks Dave, I added a new SSD harddrive instead of a normal SATA harddrive as well as included my ip in the hosts file also I have included 'skip-name-resolv' as you mentioned to not to resolv and tested for around 250 concurrent calls, connection was going through fine...next week I would be

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-11-05 Thread Matt Riddell
On 23/10/09 6:11 AM, jonas kellens wrote: On Thu, 2009-10-22 at 13:45 +1300, Matt Riddell wrote: It's really simple you just read from standard input and write to standard output. If you tell us a programming language you'd like to use (i.e. php/c/perl/bash etc) we can give you a link to

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-26 Thread das sandesh
Thanks for all the information. Benaiad: I will try adding in the hosts file and try it once again, also one more that I was in regards to the harddrive, so I thought of replacing with a SSD with high read and write speeds just to check whether its going to reduce the dealy... Regards Sandesh

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-22 Thread Matt Riddell
On 22/10/09 6:52 PM, das sandesh wrote: There were 2 problems that we faced, one was at around 50 calls, few calls were just dead air, and when I saw the logs I could see that it was sent to the sip provider and after that there was no log for that particular call that was having dead air, but

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-22 Thread jonas kellens
On Thu, 2009-10-22 at 13:45 +1300, Matt Riddell wrote: It's really simple you just read from standard input and write to standard output. If you tell us a programming language you'd like to use (i.e. php/c/perl/bash etc) we can give you a link to some docs and examples. Might I

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-22 Thread Steve Edwards
On Thu, 22 Oct 2009, jonas kellens wrote: On Thu, 2009-10-22 at 13:45 +1300, Matt Riddell wrote: It's really simple you just read from standard input and write to standard output. If you tell us a programming language you'd like to use (i.e. php/c/perl/bash etc) we can give you a link to

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-22 Thread Benaiad
Abdulmnem Benaiad Almontaha CTO Almontaha IT Co. cell: +218 92 5200025 fax: +218 21 4835263 www.almontaha.com.ly On Wed, Oct 21, 2009 at 11:57 PM, das sandesh sandesh...@gmail.com wrote: Hi Matt, I already used the tuning-primer.sh script to enhance the values for the parameters,

[asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread das sandesh
Hi, I tried getting our server setup for 400-500 simultaneous calls, calls were going through properly but at around 200-250 calls, mysql (connect ...) statement was taking at least 5-10 sec to connect to the database. I optimized all possible parameters in my.cnf: max_connection=1000

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread Steve Edwards
On Wed, 21 Oct 2009, das sandesh wrote: I tried getting our server setup for 400-500 simultaneous calls, calls were going through properly but at around 200-250 calls, mysql (connect ...) statement was taking at least 5-10 sec to connect to the database. I optimized all possible parameters

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread David Backeberg
On Wed, Oct 21, 2009 at 2:30 PM, das sandesh sandesh...@gmail.com wrote: I tried getting our server setup for 400-500 simultaneous calls, calls were going through properly but at around 200-250 calls, mysql (connect ...) statement was taking at least 5-10 sec to connect to the database. I

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread das sandesh
Hi Steve, Thanks for your reply. I am using only asterisk code (dial plan) in extensions.conf which also includes connection to the database: like exten =n,1, MYSQL(connect connid ipaddr uname pwd database) and then the required select queries and the clear and Disconnect the connection.

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread Jai Rangi
I think the key point is how many calls per second. That's what mysql is concerned about. Other than that it is just asterisk. Did you monitor the mysql, try log-slow-queries and set the time to 1 second. -Jai On Wed, Oct 21, 2009 at 12:57 PM, das sandesh sandesh...@gmail.com wrote: Hi Steve,

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread Matt Riddell
On 22/10/09 7:30 AM, das sandesh wrote: Hi, I tried getting our server setup for 400-500 simultaneous calls, calls were going through properly but at around 200-250 calls, mysql (connect ...) statement was taking at least 5-10 sec to connect to the database. I optimized all possible

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread Matt Riddell
On 22/10/09 8:56 AM, David Backeberg wrote: On Wed, Oct 21, 2009 at 2:30 PM, das sandeshsandesh...@gmail.com wrote: I tried getting our server setup for 400-500 simultaneous calls, calls were going through properly but at around 200-250 calls, mysql (connect ...) statement was taking at least

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread Steve Edwards
On Wed, 21 Oct 2009, das sandesh wrote: I am using only asterisk code (dial plan) in extensions.conf which also includes connection to the database: like exten =n,1, MYSQL(connect connid ipaddr uname pwd database) and then the required select queries and the clear and Disconnect

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread das sandesh
Hi Matt, I already used the tuning-primer.sh script to enhance the values for the parameters, but still it was being slow to connect when there are lot of calls (calls around 150-200 calls). Also I reduced mysql queries in the code as well as many other steps, but only problem coming is with

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread Steve Edwards
On Wed, 21 Oct 2009, Steve Edwards wrote: I'd take a look at using AGIs written in C. They make nice little building blocks. They execute very quickly and can cleanup your dialplan. And you can debug them (AGIs in any language) from the command line completely outside of Asterisk. --

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread Matt Riddell
On 22/10/09 10:57 AM, das sandesh wrote: Hi Matt, I already used the tuning-primer.sh script to enhance the values for the parameters, but still it was being slow to connect when there are lot of calls (calls around 150-200 calls). Also I reduced mysql queries in the code as well as many

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread Jai Rangi
The thing is, concurrent calls won't make any difference, it's the calls per second. And really you're unlikely to use too many queries per sec. Exactly and you can see the slow-log-queries if mysql is taking time. -Jai On Wed, Oct 21, 2009 at 3:51 PM, Matt Riddell li...@venturevoip.com

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread covici
Steve Edwards asterisk@sedwards.com wrote: On Wed, 21 Oct 2009, Steve Edwards wrote: I'd take a look at using AGIs written in C. They make nice little building blocks. They execute very quickly and can cleanup your dialplan. And you can debug them (AGIs in any language) from the

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread Matt Riddell
On 22/10/09 1:41 PM, cov...@ccs.covici.com wrote: Steve Edwardsasterisk@sedwards.com wrote: On Wed, 21 Oct 2009, Steve Edwards wrote: I'd take a look at using AGIs written in C. They make nice little building blocks. They execute very quickly and can cleanup your dialplan. And you

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread Steve Edwards
On Wed, 21 Oct 2009, Steve Edwards wrote: I'd take a look at using AGIs written in C. They make nice little building blocks. They execute very quickly and can cleanup your dialplan. And you can debug them (AGIs in any language) from the command line completely outside of Asterisk. On

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread covici
Steve Edwards asterisk@sedwards.com wrote: On Wed, 21 Oct 2009, Steve Edwards wrote: I'd take a look at using AGIs written in C. They make nice little building blocks. They execute very quickly and can cleanup your dialplan. And you can debug them (AGIs in any language) from

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread Jeff LaCoursiere
Steve Edwards asterisk@sedwards.com wrote: Since I'm an old-school C programmer, I use emacs as my editor. I fire up gdb (the GNU C (amongst other languages) debugger) in a window, give it a command like b main; r dummy-input-for-block-ani and I can step through my program line by line,

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread Andrew Hakman
Hey now, I'm a newschool programmer and I use vim (and vi, when necessary). Andrew On Wed, Oct 21, 2009 at 8:02 PM, Jeff LaCoursiere j...@jeff.net wrote: Steve Edwards asterisk@sedwards.com wrote: Since I'm an old-school C programmer, I use emacs as my editor. I fire up gdb (the GNU C

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread Matt Riddell
On 22/10/09 2:54 PM, cov...@ccs.covici.com wrote: OK, but how do write the C program -- the Perl and php agis have defined functions for the agi commands, how do you do this in c? There is a library (haven't used it myself) http://sourceforge.net/projects/cagi/ Basically you read from the

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread Paul Hales
Jeff LaCoursiere wrote: Steve Edwards asterisk@sedwards.com wrote: Since I'm an old-school C programmer, I use emacs as my editor. I fire up gdb (the GNU C (amongst other languages) debugger) in a window, give it a command like b main; r dummy-input-for-block-ani and I can step

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread Steve Edwards
On Wed, 21 Oct 2009, cov...@ccs.covici.com wrote: OK, but how do write the C program -- the Perl and php agis have defined functions for the agi commands, how do you do this in c? The same way. All languages need a library. Either you find a library that talks AGI or you write one. I wrote

Re: [asterisk-users] Concurrent calls including mysql taking lot of time for execution

2009-10-21 Thread das sandesh
There were 2 problems that we faced, one was at around 50 calls, few calls were just dead air, and when I saw the logs I could see that it was sent to the sip provider and after that there was no log for that particular call that was having dead air, but at around 200 to 250, we could see that