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

[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 <sandesh440 at gmail.com> wrote:

> 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 =>nxxxxxxxx,1, MYSQL(connect connid <ipaddr> uname pwd database) and
> then the required select queries and the clear and Disconnect the
> connection.
>
> When the live calls are made to test and at 200th or at around 250th call
> there is a point where it took like 5-10 sec just to connect to the database
> and in the mean time we get dead air for that period of time......how can we
> change the type of connection that you mentioned? Or might be is it good to
> go with dual quad core processor instead of just one inorder to handle the
> call capacity as well as connections?
>
> Regards
> Sandesh.
>
>
> On Wed, Oct 21, 2009 at 2:21 PM, Steve Edwards <asterisk.org at sedwards.com>wrote:
>
>> 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 in my.cnf:
>>
>> This isn't a "MySQL" performance list and I'm not an "expert," but...
>>
>> I cobbled up a little C program that created 1,000 concurrent connections
>> to my database and it takes 0.15 seconds on an "AMD Phenom(tm) 8650
>> Triple-Core Processor." I confirmed via netstat that there were 1,000
>> connections. Opening and closing a single connection 1,000 times was still
>> less than a second.
>>
>> This was connecting to "localhost" so it used the UNIX socket. Changing to
>> a TCP socket took 0.19 seconds.
>>
>> I'd look elsewhere -- it's not the MySQL connection that's the problem.
>>
>> How are you connecting? Is in in an AGI? What language are you using? What
>> are you doing with MySQL? A few more details will help :)
>>
>> --
>> Thanks in advance,
>> -------------------------------------------------------------------------
>> Steve Edwards       sedwards at sedwards.com      Voice: +1-760-468-3867 PST
>> Newline                                              Fax: +1-760-731-3000
>>
>> _______________________________________________
>> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>>
>> asterisk-users mailing list
>> To UNSUBSCRIBE or update options visit:
>>   http://lists.digium.com/mailman/listinfo/asterisk-users
>>
>
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20091021/7b07814d/attachment.htm