<div dir="ltr"><br clear="all">Abdulmnem Benaiad<br> Almontaha CTO<br> Almontaha IT Co.<br> cell: +218 92 5200025<br> fax: +218 21 4835263<br> <a href="http://www.almontaha.com.ly">www.almontaha.com.ly</a><br>
<br><br><div class="gmail_quote">On Wed, Oct 21, 2009 at 11:57 PM, das sandesh <span dir="ltr"><<a href="mailto:sandesh440@gmail.com">sandesh440@gmail.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;">
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><font color="#888888">Sandesh</font><div><div></div><div class="h5"><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" target="_blank">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>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><br></div></div></blockquote></div></div></div></blockquote><div><br><br>
Regarding Mysql delay, I've faced this problem before in my local
network and this problem has been solved by adding all of my servers IP's and names
in the "/etc/hosts" file. <br>
even when connecting locally, I think , asterisk will use a real IP
instead of 127.0.0.1 when connecting to mysql and mysql will try to
resolve it's name, and this step will take some time.<br>
<br>
Regards.<br>
<br>
--<br>
Benaiad<br> </div></div><br></div>