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