<!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>Hi David,<br>
<br>
The performance degradation of the cdr procedure (from CP) may be
because:<br>
- acc table got larger as polluted with old acc STOP/START
records which never matched into a call; I suggest to move into an
archive table whatever acc record is older than 2 days (you do not
have calls longer than 2 days :) )<br>
- cdr table may become large if you are continuously
accumulating data inthere. Be sure you are rotating or consuming
the data from the CDR table.<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 03/18/2013 04:36 PM, David Crow wrote:
<blockquote
cite="mid:3C131E7252D2744FB12C4269037C876395B131F5@VC3-EXCH-02.vc3.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="Generator" content="Microsoft Word 14 (filtered
medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">I’ve got an opensips system that we’ve been
running for about 3 years now. Recently I’ve noticed that the
load average on the system has been creeping up slowly over
time.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’ve narrowed this down to the cdr
generation script in the opensips-cp, which seems to be taking
longer and longer to finish.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I was looking at the mysql database and it
looks like both the acc and cdrs tables just continue to
grow. I know that I can remove stuff from the CDR table, but
I’m not really sure about the ACC table. Does anyone have
scripts that regularly purge old stuff from these databases?
Also what do I do now with them as large as they are?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span style="font-size: 14pt; color:
rgb(31, 73, 125);">David Crow</span></b><b><span
style="font-size: 14pt; color: gray;">
</span></b><b><span style="color: gray;">| </span></b><b><span
style="font-size: 10pt; color: gray;">Senior Systems
Architect</span></b><span style="font-size: 10pt; color:
gray;"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size: 10pt; color:
gray;">1301 Gervais Street, Suite 1800 | Columbia, SC
29201</span></b><span style="font-size: 10pt; color:
gray;"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size: 10pt; color:
gray;">(d) 803.978.2727
</span></b><b><span style="font-size: 10pt; color: gray;">|
</span></b><b><span style="font-size: 10pt; color: gray;">(f)
803.733.5888</span></b><span style="font-size: 10pt;
color: gray;"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size: 10pt;"><a
moz-do-not-send="true" href="mailto:david.crow@vc3.com"><span
style="color: blue;">david.crow@vc3.com</span></a><span
style="color: gray;">|
</span></span></b><a moz-do-not-send="true"
href="http://www.vc3.com/"><b><span style="font-size: 10pt;
color: gray;">www.VC3.com</span></b></a><b><span
style="font-size: 10pt; color: gray;"><o:p></o:p></span></b></p>
<p class="MsoNormal"><b><sup><span style="font-size: 18pt;
color: gray;">Follow us:</span></sup></b><span
style="font-size: 18pt; color: gray;">
</span><a moz-do-not-send="true"
href="http://www.facebook.com/VC3Inc"><span style="color:
rgb(31, 73, 125); text-decoration: none;"><img
id="Picture_x0020_20"
src="cid:part1.03040701.04000301@opensips.org"
alt="Description: Description: Description: Description:
Description: cid:image002.png@01CC30E6.8E093080"
border="0" height="21" width="21"></span></a><a
moz-do-not-send="true" href="http://twitter.com/#%21/VC3Inc"><span
style="color: rgb(31, 73, 125); text-decoration: none;"><img
id="Picture_x0020_25"
src="cid:part2.09080707.01090802@opensips.org"
alt="Description: Description: Description: Description:
Description: cid:image004.png@01CC30E6.8E093080"
border="0" height="22" width="22"></span></a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><img
id="Picture_x0020_28"
src="cid:part3.06070709.05030507@opensips.org" border="0"
height="100" width="100"></span>
<img id="Picture_x0020_1"
src="cid:part4.01000708.01040406@opensips.org" border="0"
height="102" width="192"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</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>