Cleaning up import tables and action log
Hi, Is anyone of you using code to periodically purge records from import_records, import_biblios, import_batches and/or action_logs ? If so, would it be an idea to include such code into cleanup_database.pl in misc/cronjobs ? Thanks for sharing, Marcel
Marcel de Rooy <M.de.Rooy@rijksmuseum.nl>
Is anyone of you using code to periodically purge records from import_records, import_biblios, import_batches and/or action_logs ? If so, would it be an idea to include such code into cleanup_database.pl in misc/cronjobs ?
I'm pretty sure we do at one of our more resource-starved servers (library-owned and upgrade will happen when budget permits). It seems like a good idea to add them to cleanup_database. I think action_logs help for monitoring sometimes, so it would be nice to have that be optional. Apart from debugging, is there much help in keeping import_* around for longer? Thanks, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. http://koha-community.org supporter, web and LMS developer, statistician. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire for Koha work http://www.software.coop/products/koha
Le 17/10/2011 12:17, Marcel de Rooy a écrit :
Hi,
Is anyone of you using code to periodically purge records from import_records, import_biblios, import_batches and/or action_logs ?
If so, would it be an idea to include such code into cleanup_database.pl in misc/cronjobs ? +1 Sounds a very good idea. We have already made a dirty mysql < "truncate xxx" on some setups IIRC. Would be better to have it in cleanup_database.
I also agree it should be driven by a parameter, like the number in days to keep/clean. Something like cleanup_database --import 90 --action_logs 180 (90 days for import_* tables and 180 for action logs in this example) And if no parameter are given, either do nothing or remove after a default duration (30 for import ? 90 for action_logs ?) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08
participants (3)
-
Marcel de Rooy -
MJ Ray -
Paul Poulain