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
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
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
On 18/02/10 11:47, Chris Nighswonger wrote:
On Thu, Feb 18, 2010 at 5:05 AM, Paul Poulainpaul.poul...@biblibre.com
wrote:
Le 17/02/2010 21:10, Chris Cormack a écrit :
2010/2/18 Clay Foutsclay.fo...@liblime.com:
It depends, actually. For tables without FK constraints (like Koha's
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
Hi,
On Thu, Feb 18, 2010 at 7:45 AM, Colin Campbell
colin.campb...@ptfs-europe.com wrote:
If you have everything in one ibdata file it can be difficult to recover
space.
Yes, that's why is a good idea to use a separate file for each InnoDB
table; you can enable this by turning on the
On 18/02/10 12:42, Galen Charlton wrote:
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.
I'm not sure it is the default. It
On Thu, Feb 18, 2010 at 7:46 AM, Nahuel ANGELINETTI
nahuel.angeline...@biblibre.com wrote:
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
David Schuster dschu...@... writes:
I've been in contact with some Evergreen folks that are going to start
working on developing a Kids Catalog type interface that will be targeted
toward k-3 grade students to use. Similar to the old Carl catalog I
suspect, but they are starting from