On Tue, Jan 17, 2012 at 03:19:13PM +0100, Zeno Tajoli wrote: > 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 > > The engine of those tables is InnoDB. > > What do you think about change the engine to MYISAM ? > I think that MYISAM is a better engine for table with many write/delete.
MyISAM locks the table rather than the row for update/insert so its generally less optimal for tables which are getting lots of inserts. I did some benchmarking on an application that was using some mysql tables for high throughput logging and innodb was handling that workload better. C. -- Colin Campbell Chief Software Engineer, PTFS Europe Limited Content Management and Library Solutions +44 (0) 800 756 6803 (phone) +44 (0) 7759 633626 (mobile) colin.campb...@ptfs-europe.com skype: colin_campbell2 http://www.ptfs-europe.com _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org 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/
