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)?
Thanks Sandesh On Wed, Oct 21, 2009 at 3:57 PM, Matt Riddell <li...@venturevoip.com> wrote: > On 22/10/09 7:30 AM, das sandesh wrote: > > Hi, > > > > 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: > > Without knowing what you're optimising you're unlikely to have much luck > just setting values. > > We have had quite good success with the tunish-primer.sh script: > > http://www.day32.com/MySQL/ > http://www.day32.com/MySQL/tuning-primer.sh > > We run with MySQL at about 500 queries per second with no problems - we > don't however use Asterisk's MySQL libraries. > > -- > 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