[asterisk-users] Concurrent calls including mysql taking lot of time for execution

[Jai Rangi]

" The thing is, concurrent calls won't make any difference, it's the calls
per second.
And really you're unlikely to use too many queries per sec. "
Exactly and you can see the slow-log-queries if mysql is taking time.

-Jai




On Wed, Oct 21, 2009 at 3:51 PM, Matt Riddell <lists at venturevoip.com> wrote:

> On 22/10/09 10:57 AM, das sandesh wrote:
> > Hi Matt,
> >
> > 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)?
>
> The thing is, concurrent calls won't make any difference, it's the calls
> per second.
>
> And really you're unlikely to use too many queries per sec.
>
> Seriously, use at least AGI (fastAGI would be better but AGI will at
> least give you a start).
>
> So:
>
> 1. Do you get the same delay if you use MySQL command line at the same
> time?
>
> 2. Do you have a programming language you know well enough to connect to
> MySQL in?
>
> --
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20091021/9abf33b2/attachment.htm