Hi Matt,<br><br>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)?<br>
<br>Thanks<br>Sandesh<br><br><div class="gmail_quote">On Wed, Oct 21, 2009 at 3:57 PM, Matt Riddell <span dir="ltr"><<a href="mailto:lists@venturevoip.com">lists@venturevoip.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">On 22/10/09 7:30 AM, das sandesh wrote:<br>
> Hi,<br>
><br>
> I tried getting our server setup for 400-500 simultaneous calls, calls<br>
> were going through properly but at around 200-250 calls, mysql (connect<br>
> ...) statement was taking at least 5-10 sec to connect to the database.<br>
> I optimized all possible parameters in my.cnf:<br>
<br>
</div>Without knowing what you're optimising you're unlikely to have much luck<br>
just setting values.<br>
<br>
We have had quite good success with the tunish-primer.sh script:<br>
<br>
<a href="http://www.day32.com/MySQL/" target="_blank">http://www.day32.com/MySQL/</a><br>
<a href="http://www.day32.com/MySQL/tuning-primer.sh" target="_blank">http://www.day32.com/MySQL/tuning-primer.sh</a><br>
<br>
We run with MySQL at about 500 queries per second with no problems - we<br>
don't however use Asterisk's MySQL libraries.<br>
<br>
--<br>
Cheers,<br>
<br>
Matt Riddell<br>
Director<br>
_______________________________________________<br>
<br>
<a href="http://www.venturevoip.com/news.php" target="_blank">http://www.venturevoip.com/news.php</a> (Daily Asterisk News)<br>
<a href="http://www.venturevoip.com/st.php" target="_blank">http://www.venturevoip.com/st.php</a> (SmoothTorque Predictive Dialer)<br>
<a href="http://www.venturevoip.com/c3.php" target="_blank">http://www.venturevoip.com/c3.php</a> (ConduIT3 PABX Systems)<br>
<div><div></div><div class="h5"><br>
_______________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</div></div></blockquote></div><br>