Re: [OpenSIPS-Users] OpenSIPs Database Maintenance

2013-03-19 Thread Bogdan-Andrei Iancu 


  
  
Hi David,
  
  The performance degradation of the cdr procedure (from CP) may be
  because:
   - 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 :) )
   - 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.
  
  Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 03/18/2013 04:36 PM, David Crow wrote:

  
  
  
  
  
Ive got an opensips system that weve been
  running for about 3 years now. Recently Ive noticed that the
  load average on the system has been creeping up slowly over
  time.

Ive 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
  Im 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
david.c...@vc3.com|
  www.VC3.com
Follow us:
  


  


  
  

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


  

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] OpenSIPs Database Maintenance

2013-03-18 Thread David Crow 
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
david.c...@vc3.commailto:david.c...@vc3.com| www.VC3.comhttp://www.vc3.com/
Follow us: [Description: Description: Description: Description: Description: 
cid:image002.png@01CC30E6.8E093080] http://www.facebook.com/VC3Inc 
[Description: Description: Description: Description: Description: 
cid:image004.png@01CC30E6.8E093080] http://twitter.com/#!/VC3Inc

[cid:image003.jpg@01CE23C4.0EB5A2F0]   [cid:image006.jpg@01CE23C4.72A6CFA0]


inline: image001.pnginline: image002.pnginline: image003.jpginline: image006.jpg___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users