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.campbell@ptfs-europe.com skype: colin_campbell2 http://www.ptfs-europe.com