Rotating CDR records inside mysql - anyone does it?

1 msg	Re: dial extension number
2 msg	Patton SmartNode Help
6 msg	Help: dtmf mode
2 msg	two zaptel card
13 msg	Your 'favorite' Asterisk application.
5 msg	Call Parking with multiple lots
1 msg	nokia e51 (Christian Lox)
9 msg	Replacement for Allison
6 msg	Snom 320 Lost Settings
1 msg	app_txfax
16 msg	Peak number of calls?
2 msg	LDAP support
21 msg	Asterisk scalability
10 msg	asterisk optimalization
1 msg	No more audio with 99777 SVN version in certain...
3 msg	AsteriskIdeas.org :: Comment on submitted ideas
6 msg	Realtime problem host='dynamic' in 1.2.26.1
3 msg	Modem bridging on Asterisk (no VoIP involved)
4 msg	Voicemail - is it possible to automatically use...

Rotating CDR records inside mysql - anyone does...
\ tloginbr-asterisk (22 Jan 2008)
. \ Atis Lezdins (22 Jan 2008)
. . \ tloginbr-asterisk (23 Jan 2008)
. \ Darryl Dunkin (23 Jan 2008)

Subject:	Rotating CDR records inside mysql - anyone does it?
Group:	Asterisk-users
From:	tloginbr-asterisk
Date:	22 Jan 2008

Hi everyone,

I have a few asterisk machines doing PSTN calls, and I keep track of
all cdr in a single machine running mysql 5. Since I have a very
large amount of records in there, its getting pretty slow to query
the database, so I'm wondering if anyone does some type of log
rotating, like save the data for a single month inside a separate
table and do that every month, so I keep the tables small enough to
build my reports. I know this is mainly a mysql question, but maybe
someone here has some stored procedures that do this already...

Thanks for all help,

Thiago

Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento!
http://br.mail.yahoo.com/

_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users