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?
-David From: [email protected] [mailto:[email protected]] On Behalf Of Adrian Georgescu Sent: Friday, February 21, 2014 6:31 PM To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] Truncating ACC and CDRs 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. -- Adrian On 21 Feb 2014, at 16:49, David Crow <[email protected]<mailto:[email protected]>> wrote: 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 [email protected]<mailto:[email protected]>| www.VC3.com<http://www.vc3.com/> Follow us: <image001.png><http://www.facebook.com/VC3Inc><image002.png><http://twitter.com/#!/VC3Inc> _______________________________________________ Users mailing list [email protected]<mailto:[email protected]> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
