On 18/02/10 11:47, Chris Nighswonger wrote: > On Thu, Feb 18, 2010 at 5:05 AM, Paul Poulain<paul.poul...@biblibre.com> > wrote: >> Le 17/02/2010 21:10, Chris Cormack a écrit : >>> 2010/2/18 Clay Fouts<clay.fo...@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.campb...@ptfs-europe.com skype: colin_campbell2 http://www.ptfs-europe.com _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel