Not my cup of tea, but I think I'd be trying an ODBC connection to reduce some overhead here.
_____ From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@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....@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 sedwa...@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