-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
#!/bin/bash
echo "delete from cdr where calldate <= DATE_SUB(NOW(),interval 1
month);" | mysql asteriskcdrdb
Chris Modesitt wrote:
> Hi all, I have been using AMP for over a year for our companies PBX, we
> process about 2500 calls a day and our CDR reporting has slowed down a
> crawl because of it. (Several million entries now). What would be the
> easies way to purge all of the CDR records that are older than XX days
> on a nightly basis? Any suggestions would be greatly appreciated.
>
>
>
> Thanks
>
>
>
> Chris
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFDxX+Wy9wPyZpnL2URAhcDAJ96jEa2qQ5DF+qZKj7VsyX4HD9AvwCeOfjB
umtxZr1MhKm2WoNvmTgLwCo=
=pYRP
-----END PGP SIGNATURE-----
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
|
