[Koha-devel] Koha sessions table is ridiculously huge

Paul Poulain paul.poulain at biblibre.com
Thu Feb 18 11:05:56 CET 2010


Le 17/02/2010 21:10, Chris Cormack a écrit :
> 2010/2/18 Clay Fouts <clay.fouts at liblime.com>:
>   
>> It depends, actually. For tables without FK constraints (like Koha's
>> "sessions"), truncation is instantaneous in MySQL.
>>
>>     
> Not when they tried it yesterday :-)
>
> It does depend, InnoDB can do some strange things.
>   
including not freeing space in the file system even if you truncate the
table :(

-- 
Paul POULAIN
http://www.biblibre.com
Expert en Logiciels Libres pour l'info-doc
Tel : (33) 4 91 81 35 08




More information about the Koha-devel mailing list