" The thing is, concurrent calls won't make any difference, it's the calls per second. And really you're unlikely to use too many queries per sec. " Exactly and you can see the slow-log-queries if mysql is taking time.
-Jai On Wed, Oct 21, 2009 at 3:51 PM, Matt Riddell <li...@venturevoip.com> wrote: > On 22/10/09 10:57 AM, das sandesh wrote: > > Hi Matt, > > > > I already used the tuning-primer.sh script to enhance the values for the > > parameters, but still it was being slow to connect when there are lot > > of calls (calls around 150-200 calls). Also I reduced mysql queries in > > the code as well as many other steps, but only problem coming is with > > repect to the connection from asterisk to mysql (also I am using <direct > > ip address> and not the dns name).....is it better to use any additional > > mysql server apart from this application server? or adding additional > > hardware would help (like dual quad core)? > > The thing is, concurrent calls won't make any difference, it's the calls > per second. > > And really you're unlikely to use too many queries per sec. > > Seriously, use at least AGI (fastAGI would be better but AGI will at > least give you a start). > > So: > > 1. Do you get the same delay if you use MySQL command line at the same > time? > > 2. Do you have a programming language you know well enough to connect to > MySQL in? > > -- > Cheers, > > Matt Riddell > Director > _______________________________________________ > > http://www.venturevoip.com/news.php (Daily Asterisk News) > http://www.venturevoip.com/st.php (SmoothTorque Predictive Dialer) > http://www.venturevoip.com/c3.php (ConduIT3 PABX Systems) > > _______________________________________________ > -- 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