[asterisk-users] MYSQL queries from dial plan

[Peter Lindqvist]

On Jan 4, 2010, at 3:06 PM, Steve Edwards wrote:

> On Mon, 4 Jan 2010, Neeraj Chand wrote:
> 
>> I currently run small scale mysql queries from the dialplan
> 
> [snip]
> 
>> This currently takes about 4 seconds to complete.
>> 
>> If I run two simultaneous queries, this goes up to about 9 seconds for 
>> both queries to complete.
> 
> 4 seconds for a query is a bit extreme. 9 seconds for 2 simultaneous 
> queries reinforce my guess that it is a database issue, not an Asterisk 
> issue.
> 
> What sort of response time to you get if you issue the queries from the 
> mysql command prompt?

This have happened to me in various situations and is usually a result of reverse DNS lookups failing on the MySQL side. See: http://dev.mysql.com/doc/refman/5.0/en/dns.html
for a solution to that if that is the issue.

Best regards,

Peter Lindqvist
Voxion Ltd.
www.voxion.net