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