[SR-Users] mysql queries per sec forever rising...almost

[Andres]

On 6/4/2010 6:18 PM, Anders wrote:
> Hi,
>
> I use Munin to try to understand what's going on on the server that
> runs Kamailio (with Siremis). One thing that puzzles me is that if I
> look at the MySql queries per second, it just keeps going up. The
> number rises during the time with calls - the more calls the more it
> rises - and then when there are no calls, it stays at the same level.
> And this is what I don't understand - when Kamailio is doing nothing,
> why are there 5k queries per second? Sometimes - every few weeks - it
> takes a steep drop to very few queries per second... - and then back
> to rising again. Is this a database issue, a Siremis issue, or a Munin
> issue? Or is it just something I don't understand that it's supposed
> to keep rising forever?
>    
Maybe you are processing keep alives if the UA is using OPTIONS or 
NOTIFY.  I have seen that exact symptom you describe.  The solution was 
to respond immediately to keep alive messages without any further 
processing.

Andres
http://www.telesip.net
> Thanks!
>
> //Anders
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>