[Koha-devel] Tables from InnoDB to MYISAM

[Paul Poulain]

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