[OpenSIPS-Users] Truncating ACC and CDRs

David Crow David.Crow at vc3.com
Fri Feb 21 19:49:01 CET 2014


I've got an opensips proxy that I just use for PSTN routing, no billing or anything is done from this system.
I only use the cdrs to identify when provider a call went to or from.

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?

Thanks,

David Crow | Senior Systems Architect
1301 Gervais Street, Suite 1800 | Columbia, SC 29201
(d) 803.978.2727 | (f) 803.733.5888
david.crow at vc3.com<mailto:david.crow at vc3.com>| www.VC3.com<http://www.vc3.com/>
Follow us: [Description: Description: Description: Description: Description: cid:image002.png at 01CC30E6.8E093080] <http://www.facebook.com/VC3Inc> [Description: Description: Description: Description: Description: cid:image004.png at 01CC30E6.8E093080] <http://twitter.com/#!/VC3Inc>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20140221/ac9249ae/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 1198 bytes
Desc: image001.png
URL: <http://lists.opensips.org/pipermail/users/attachments/20140221/ac9249ae/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 1325 bytes
Desc: image002.png
URL: <http://lists.opensips.org/pipermail/users/attachments/20140221/ac9249ae/attachment-0003.png>


More information about the Users mailing list