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.
I've narrowed this down to the cdr generation script in the opensips-cp, which seems to be taking longer and longer to finish. 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? 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: [Description: Description: Description: Description: Description: cid:[email protected]] <http://www.facebook.com/VC3Inc> [Description: Description: Description: Description: Description: cid:[email protected]] <http://twitter.com/#!/VC3Inc> [cid:[email protected]] [cid:[email protected]]
<<inline: image001.png>>
<<inline: image002.png>>
<<inline: image003.jpg>>
<<inline: image006.jpg>>
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
