Hi Henning,<br><br><div class="gmail_quote">On Wed, Aug 17, 2011 at 11:33 AM, Henning Westerholt <span dir="ltr"><<a href="mailto:henning.westerholt@1und1.de">henning.westerholt@1und1.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">On Wednesday 17 August 2011, Sebastian Damm wrote:<br>
> we have a script running on our Kamailio servers which dumps all online<br>
> users with kamctl ul show, parses it and then sends it to database. (For<br>
> explanation, we started doing it this way because we noticed at least with<br>
> an older (open)ser release that SER would completely stop working for a<br>
> couple of seconds while writing registered users to database every 5<br>
> minutes. When dumping it, we don't see any disruption.)<br>
<br>
</div>what about fixing this bug instead of using this workaround? This sounds<br>
really inefficient.<br></blockquote><div><br>Actually, piping the output through awk and generating a file for LOAD DATA INFILE" is not too bad. Additionally, we need to have that data in more than one DB, which prevents us from using one of the built-in db modes. We use an own DB mode which reads only on startup and then never touches the DB again.<br>
</div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">I don't think there is a hard limit. Do you see any errors (e.g. memory<br>
allocation issues) in the server logs? Another idea, if you're somehow stuck<br>
to the old/ buggy version of the server, what about using DB_ONLY mode?<br></blockquote><div><br>I don't see any errors in the log. And actually, that's the only bug left preventing our migration from 1.5 to 3.1. And I'd say, DB_ONLY is not an option, should be a lot less performant than if Kamailio keeps the state in memory (although I haven't benchmarked it). <br>
<br>Other ideas?<br></div></div><br>Best regards,<br>Sebastian<br><br>-- <br>Dipl.-Inf.<br>Sebastian Damm - VoIP-Engineer - <a href="mailto:damm@sipgate.de">damm@sipgate.de</a><br><br>sipgate GmbH - Gladbacher Str. 74 - 40219 Düsseldorf<br>
HRB Düsseldorf 39841 - Geschäftsführer: Thilo Salmon, Tim Mois<br>Steuernummer: 106/5724/7147, Umsatzsteuer-ID: DE219349391<br><br><a href="http://www.sipgate.de">www.sipgate.de</a> - <a href="http://www.sipgate.at">www.sipgate.at</a> - <a href="http://www.sipgate.co.uk">www.sipgate.co.uk</a><br>