18 Feb
2010
18 Feb
'10
1:42 p.m.
Hi, On Thu, Feb 18, 2010 at 6:47 AM, Chris Nighswonger <cnighswonger@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@gmail.com