Le 17/02/2010 21:10, Chris Cormack a écrit :
> 2010/2/18 Clay Fouts :
>
>> 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 t
On Thu, Feb 18, 2010 at 5:05 AM, Paul Poulain wrote:
> Le 17/02/2010 21:10, Chris Cormack a écrit :
>> 2010/2/18 Clay Fouts :
>>
>>> It depends, actually. For tables without FK constraints (like Koha's
>>> "sessions"), truncation is instantaneous in MySQL.
>>>
>>>
>> Not when they tried it yesterd
Hi,
On Thu, Feb 18, 2010 at 6:47 AM, Chris Nighswonger
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,
On 18/02/10 11:47, Chris Nighswonger wrote:
> On Thu, Feb 18, 2010 at 5:05 AM, Paul Poulain
> wrote:
>> Le 17/02/2010 21:10, Chris Cormack a écrit :
>>> 2010/2/18 Clay Fouts:
>>>
It depends, actually. For tables without FK constraints (like Koha's
"sessions"), truncation is instantaneou
Hi,
Le 18/02/2010 13:42, Galen Charlton a écrit :
> Hi,
>
> On Thu, Feb 18, 2010 at 6:47 AM, Chris Nighswonger
> 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
Hi,
On Thu, Feb 18, 2010 at 7:45 AM, Colin Campbell
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 innodb_file_per_table
option in the My
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 req
On Thu, Feb 18, 2010 at 7:46 AM, Nahuel ANGELINETTI
wrote:
> Hi,
>
> Le 18/02/2010 13:42, Galen Charlton a écrit :
>>
>> Hi,
>>
>> On Thu, Feb 18, 2010 at 6:47 AM, Chris Nighswonger
>> wrote:
>>
including not freeing space in the file system even if you truncate the
table :(
David Schuster 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 scratch.
David,
Darrell Ulm writes:
>
> Hello,
>
> Working on putting sound events into Koha 3.2 but it is a bit of a pickle.
>
OK, I sent a patch for this, hopefully it was intact, but I am setup to enhance
if more is needed. We are running the code on our local 3.0 system and Koha
sounds like an Atari 260
10 matches
Mail list logo
