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?
Thanks!
//Anders
On Friday, June 4, 2010, Anders vaerge@gmail.com 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?
Thanks!
//Anders
What modules are loaded? What version of kamailio?
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?
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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
-
Alex Balashov -
Anders -
Andres -
dotnetdub