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

[Danny Nicholas]

Not my cup of tea, but I think I'd be trying an ODBC connection to reduce
some overhead here.

 

  _____  

From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of das sandesh
Sent: Wednesday, October 21, 2009 2:58 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] Concurrent calls including mysql taking lot
oftime for execution

 

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/726da2bc/attachment-0001.htm