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

[Alex Balashov]

On 06/04/2010 06:18 PM, Anders wrote:

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

Why not turn on the MySQL query log, or even do a local capture on port 
3306, and see for yourself what's going on?

-- 
Alex Balashov - Principal
Evariste Systems LLC
1170 Peachtree Street
12th Floor, Suite 1200
Atlanta, GA 30309
Tel: +1-678-954-0670
Fax: +1-404-961-1892
Web: http://www.evaristesys.com/