[asterisk-users] Asterisk Realtime pounds MySQL

[Tilghman Lesher]

On Monday 25 August 2008 17:07:18 J.M. wrote:
> > I have also reproduced the problem, albeit on the same machine, by
> > setting the "qualify" field to "yes".
>
> A more complete explanation of how I am able to reproduce the issue is:
>
> 1) Disconnect the client.
> 2) Change the client's record's "sip.qualify" field to "yes".
> 3) Connect the client.
>
> If I watch the MySQL query log I see at least a dozen of the aforementioned
> queries per second after the client has connected.
>
> To undo this:
>
> 1) Disconnect the client.
> 2) Change the client's record's "sip.qualify" field to "no".
> 3) Connect the client.
> 4) Restart the Asterisk service.
>
> Then the queries return to a normal volume.

Given that this is the case, we may want to do one of the following:
a) document that qualify=yes is incompatible with realtime, unless
rtcachefriends is turned on, b) automatically disallow qualify=yes if the
peer is realtime and caching is not turned on, or c) automatically cache
realtime peers whose qualify field is set to yes.

I am open to discussion and suggestions.  Option a is certainly the least
invasive, which doesn't change any behavior, so it's the default, but I think
that enough people would consider this behavior a bug that we might change
it.  The only question that I have is, change it to what?

-- 
Tilghman