[SR-Users] High number of aborted mysql connections

[Sergiu Pojoga]

Hi all,

I'm trying to understand why some Kamailio processes become Connor MacLeod
and go to live forever causing high # of aborted connections.

While watching in time over *SHOW PROCESSLIST*, some 12 kamailio
connections in *SLEEP* state, most of them are reused over time (time value
gets reset). However, a select few go on to SLEEP forever for as much as
the mysql's *wait_timeout* allows them to. Default was 28800 sec, that's
how long they lived. If I lower this to say 600 sec, even higher abort rate
is observed.

I suppose my questions are:

   1. Is this normal to have so many SLEEPing connections?
   2. What is the recommended MySQL *wait_timeout* value under Kamailio?
   3. Any other suggestions as to why such a high rate of aborted
   connections?

Merci!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20180930/955665c5/attachment.html>