[Koha-devel] Cleaning up import tables and action log
Paul Poulain
paul.poulain at biblibre.com
Tue Oct 25 11:17:22 CEST 2011
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
More information about the Koha-devel
mailing list