18 Feb
2010
18 Feb
'10
11:47 a.m.
On Thu, Feb 18, 2010 at 5:05 AM, Paul Poulain <paul.poulain@biblibre.com> wrote:
Le 17/02/2010 21:10, Chris Cormack a écrit :
2010/2/18 Clay Fouts <clay.fouts@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