Hi, Le 18/02/2010 13:42, Galen Charlton a écrit : > Hi, > > On Thu, Feb 18, 2010 at 6:47 AM, Chris Nighswonger > <cnighswon...@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. > >
Usually, in all our installs we change the engine for "session" and "zebraqueue" tables to MyISAM. And add a cronjob that clean the both tables every night. bests, -- Nahuel ANGELINETTI _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
