Le 17/01/2012 15:19, Zeno Tajoli a écrit : > Hi to all, > > to mantain a good Koha system is import to use the cron job > 'cleanup_database.pl'. > > This script delete lines from tables > > message_queue > need_merge_authorities > sessions > zebraqueue I'm for it: * innoDB has a *big* problem with deletion, and space is not retrived. so those tables, that have temporary data only are good candidates to be myISAM * those tables don't have any foreign constraint, that myISAM don't manage, so it's OK * those tables are very small, fast to write, so the lock table issue that Colin rises is not a big deal.
We have this on all our customers, without any performance issue. (not sure for merge_authorities, but sure for sessions & zebraqueue) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08 _______________________________________________ Koha-devel mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
