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 <[email protected]>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 [email protected] 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
