[Koha-devel] Koha sessions table is ridiculously huge

[Colin Campbell]

On 18/02/10 11:47, Chris Nighswonger wrote:
> 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?
mysql says no
http://bugs.mysql.com/bug.php?id=1287

If you have everything in one ibdata file it can be difficult to recover 
space.

Colin


-- 
Colin Campbell
Chief Software Engineer,
PTFS Europe Limited
Content Management and Library Solutions
+44 (0) 208 366 1295 (phone)
+44 (0) 7759 633626  (mobile)
colin.campbell at ptfs-europe.com
skype: colin_campbell2

http://www.ptfs-europe.com