[sr-dev] [kamailio] Database timeout over SSL? (#406)

[Daniel-Constantin Mierla]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20151208/07d11932/attachment.html>