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