17 Jan
2012
17 Jan
'12
4:54 p.m.
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