On 18/02/10 11:47, Chris Nighswonger wrote:
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? 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@ptfs-europe.com skype: colin_campbell2 http://www.ptfs-europe.com