<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Hello Vic,<br>
<br>
SIP tracing may be add a significant load on the DB (and on
opensips itself - as it is doing blocking DB ops) as for each
message it has to do 2 insert queries - and for a minimal call you
around 10 inserts.<br>
<br>
The idea is to minimize the traffic you trace (trace only what you
need, not all traffic) and to optimize the dumping to DB:<br>
1) use the multi-insert option (see query_buffer_size -
<a class="moz-txt-link-freetext" href="http://www.opensips.org/Resources/DocsCoreFcn19#toc71">http://www.opensips.org/Resources/DocsCoreFcn19#toc71</a>)<br>
2) consider using the flatstore DB engine (which is a
write-only very fast engine to write to files)<br>
3) consider doing the DB ops on a different opensips instance
than the one handling the traffic (active opensips is just packing
data and another one is dumping into DB) - see Homer with
sip_trace and sip_capture modules.<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<br>
On 04/15/2013 10:37 PM, Vic Jolin wrote:
<blockquote
cite="mid:CAJMx3KpJHzZ+ZkxQUAknEc+ucexAM3GzqGxBZpVej3TUQ4_Bew@mail.gmail.com"
type="cite">
<div dir="ltr">How much additional load is added when siptrace is
turned on, but the database server is different. Meaning I have
a separate DB just for doing sip traces.<br>
</div>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</body>
</html>