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

[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 =>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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20091021/34a044a8/attachment.htm