Deleting call_log data
Posted:
Sun Jan 16, 2011 12:35 pmby john_usc
I am running outta my space on my HD. I have lots or records in call_log table. I am wondering if deleting the records from call_log affects anything. also any suggestion on cleanning up the data would be greatly appreciated
Thanks
Posted:
Sun Jan 16, 2011 1:51 pmby gardo
Vicidial version? Version 2.2.1 has a script that already does that.
/usr/share/astguiclient/ADMIN_archive_log_tables.pl
Posted:
Sun Jan 16, 2011 2:19 pmby williamconley
back up your database (this reduces your database logs drastically).
turn off logging (Admin->Servers) unless you need it.
check /var/log/ for log files and folders that are excessive (and be sure they are all being rolled regularly if large and deleted after a few days).
make sure your recordings are being pushed to another server (via ftp, check out the first few jobs in "crontab -e" and ensure your ftp transfer is set up properly to remove recordings) and be sure old recordings are being deleted as well (also a script in crontab).
once set up properly, your drive space should stabilize at a specific level as old data is deleted and new data is created daily. EXCEPT that your list will grow forever unless you delete old lists, as long as you archive and later transfer your logs to another server or delete them from mysql.