I think the key point is how many calls per second. That's what mysql is concerned about. Other than that it is just asterisk. Did you monitor the mysql, try log-slow-queries and set the time to 1 second. <br><br>-Jai<br>
<br><div class="gmail_quote">On Wed, Oct 21, 2009 at 12: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 Steve,<br><br>Thanks for your reply.<br><br>I am using only asterisk code (dial plan) in extensions.conf which also includes connection to the database: like <br>exten =>nxxxxxxxx,1, MYSQL(connect connid <ipaddr> uname pwd database) and then the required select queries and the clear and Disconnect the connection. <br>
<br>When the live calls are made to test and at 200th or at around 250th call there is a point where it took like 5-10 sec just to connect to the database and in the mean time we get dead air for that period of time......how can we change the type of connection that you mentioned? Or might be is it good to go with dual quad core processor instead of just one inorder to handle the call capacity as well as connections?<br>
<br>Regards<br><font color="#888888">Sandesh.</font><div><div></div><div class="h5"><br><br><div class="gmail_quote">On Wed, Oct 21, 2009 at 2:21 PM, Steve Edwards <span dir="ltr"><<a href="http://asterisk.org" target="_blank">asterisk.org</a>@<a href="http://sedwards.com" target="_blank">sedwards.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 Wed, 21 Oct 2009, das sandesh wrote:<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>This isn't a "MySQL" performance list and I'm not an "expert," but...<br>
<br>
I cobbled up a little C program that created 1,000 concurrent connections<br>
to my database and it takes 0.15 seconds on an "AMD Phenom(tm) 8650<br>
Triple-Core Processor." I confirmed via netstat that there were 1,000<br>
connections. Opening and closing a single connection 1,000 times was still<br>
less than a second.<br>
<br>
This was connecting to "localhost" so it used the UNIX socket. Changing to<br>
a TCP socket took 0.19 seconds.<br>
<br>
I'd look elsewhere -- it's not the MySQL connection that's the problem.<br>
<br>
How are you connecting? Is in in an AGI? What language are you using? What<br>
are you doing with MySQL? A few more details will help :)<br>
<br>
--<br>
Thanks in advance,<br>
-------------------------------------------------------------------------<br>
Steve Edwards <a href="mailto:sedwards@sedwards.com" target="_blank">sedwards@sedwards.com</a> Voice: +1-760-468-3867 PST<br>
Newline Fax: +1-760-731-3000<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>
</blockquote></div><br>
</div></div><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></blockquote></div><br>