There are different types of kamailio processes (children), not easy to have a
framework for doing mysql pings when is nothing else to do. Also, there could
be executed code continuously but not involving mysql (e.g., receiving
keepalive requests and replying to them).
What process gets to be selected for handing a sip udp packet is decided by
kernel. For tcp, is an internal dispatcher of tcp connections based on least
loaded worker.
If you know you have some constant traffic without mysql involvement, you can
add a basic query that doesn't take resources with sqlops, like
sql_query("describe table version") or "select now()...".
Worth looking at mysql server and client library setting for connections
lifetime, maybe they have some settings there.
---
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/406#issuecomment-163030130_______________________________________________
sr-dev mailing list
[email protected]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev