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

[Matt Riddell]

On 22/10/09 6:52 PM, das sandesh wrote:
> There were 2 problems that we faced, one was at around 50 calls, few
> calls were just dead air, and when I saw the logs I could see that it
> was sent to the sip provider and after that there was no log for that
> particular call that was having dead air, but at around 200 to 250, we
> could see that MySQL(Connect connid <ipaddr> uname pwd db) statement
> took around 5-10 sec to connect to the database and then the 2 queries
> in that code got executed pretty fast (1-2sec), and so here we had the
> dead air untill the call got connected (after 5-10sec).

1-2 seconds for a query isn't really that quick.

You might also want to do

explain SQLSTATEMENT

where SQLSTATEMENT is the SQL query you are running.

-- 
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)