<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 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:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Yes, that’s the plan long term. For now, though I’m just wondering if deleting everything in the acc table will cause problems. Or does anyone have any other suggestions on how to clean this up?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#1F497D">-David<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> users-bounces@lists.opensips.org [mailto:users-bounces@lists.opensips.org]
<b>On Behalf Of </b>Adrian Georgescu<br>
<b>Sent:</b> Friday, February 21, 2014 6:31 PM<br>
<b>To:</b> OpenSIPS users mailling list<br>
<b>Subject:</b> Re: [OpenSIPS-Users] Truncating ACC and CDRs<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Any operation that writes to your MySQL database for any great length of time like trimming your table will block anything else accesing the same database. You should auto rotate tables and use non transactional table storage to be able
to trim older tables without impacting the active ones.<br>
<br>
--<span style="font-size:12.0pt"><o:p></o:p></span></p>
<div>
<p class="MsoNormal">Adrian<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
On 21 Feb 2014, at 16:49, David Crow <<a href="mailto:David.Crow@vc3.com">David.Crow@vc3.com</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">I’ve got an opensips proxy that I just use for PSTN routing, no billing or anything is done from this system.<o:p></o:p></p>
<p class="MsoNormal">I only use the cdrs to identify when provider a call went to or from.
<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Both the ACC and CDRs table have just been growing and I haven’t done anything with them and now the acc table has gotten to over 4.6 GB and it’s almost impossible to search through. I have stopped generating the CDRs for now. I would
like to just purge these tables and start over but I wasn’t sure if I would break anything if I run a truncate on the acc table. Does anything read from the ACC table other than the CDR generation script? Would it be ok to run a TRUNCATE on this table?
<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:14.0pt;color:#1F497D">David Crow</span></b><b><span style="font-size:14.0pt;color:gray">
</span><span style="color:gray">| </span></b><b><span style="font-size:10.0pt;color:gray">Senior Systems Architect</span></b><o:p></o:p></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;color:gray">1301 Gervais Street, Suite 1800 | Columbia, SC 29201</span></b><o:p></o:p></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;color:gray">(d) 803.978.2727 | (f) 803.733.5888</span></b><o:p></o:p></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt"><a href="mailto:david.crow@vc3.com"><span style="color:blue">david.crow@vc3.com</span></a><span style="color:gray">|
</span></span></b><a href="http://www.vc3.com/"><b><span style="font-size:10.0pt;color:gray">www.VC3.com</span></b></a><o:p></o:p></p>
<p class="MsoNormal"><b><sup><span style="font-size:18.0pt;color:gray">Follow us:</span></sup></b><span style="font-size:18.0pt;color:gray">
</span><a href="http://www.facebook.com/VC3Inc"><span style="color:#1F497D;text-decoration:none"><image001.png></span></a><a href="http://twitter.com/#!/VC3Inc"><span style="color:#1F497D;text-decoration:none"><image002.png></span></a><o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</blockquote>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif"">_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><o:p></o:p></span></p>
</div>
</blockquote>
</div>
</body>
</html>