[Koha-devel] Koha sessions table is ridiculously huge

[Galen Charlton]

Hi,

On Thu, Feb 18, 2010 at 6:47 AM, Chris Nighswonger
<cnighswonger at foundations.edu> wrote:
>> 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?

It's an issue with the InnoDB storage engine, not MySQL per se.
However, reclaiming space is easy enough, since by default a separate
InnoDB file is created for each table: just drop and recreate the
sessions table.  You can also use MyISAM instead of InnoDB for that
table.

Regards,

Galen
-- 
Galen Charlton
gmcharlt at gmail.com