[Koha-devel] Koha sessions table is ridiculously huge

[Chris Nighswonger]

On Thu, Feb 18, 2010 at 5:05 AM, Paul Poulain <paul.poulain at biblibre.com> wrote:
> 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 :(

Ouch! this would seem to be a mysql bug. Is there no way to ensure the
drive space is freed up?

Kind Regards,
Chris