Depends on your disk setup. Remember a table space is a virtual
filesystem that sits on top of the OS. Having one large file and
chopping a contiguous block of the disk out enables better seeks as well
as caching if the file doesn't bust the system cache. In your case it
will. One file needs to be
David Griffiths writes:
>Oracle cannot shrink datafiles (same idea as InnoDB datafiles) when data
>is deleted either.
Actually, Oracle has been able to resize data files since 7.2. It
is usually done with an 'alter tablespace ... coalesce' followed by an
'alter tablespace datafile ... resiz
In article <[EMAIL PROTECTED]>,
Jeff Mathis <[EMAIL PROTECTED]> writes:
> my understanding is that the datafiles are created when the server
> initializes, and this this is the designed and expected behavior. Most
> other database products use a similar model. Your scenario cannot
> happen. You sp
To: [EMAIL PROTECTED]
Subject: Re: InnoDB TableSpace Question
Oracle cannot shrink datafiles (same idea as InnoDB datafiles) when data
is deleted either.
David
Marc Slemko wrote:
>On Tue, 3 Aug 2004 12:42:03 -0400 , David Seltzer <[EMAIL PROTECTED]>
wrote:
>
>
>>Thanks Marc,
Actually, Oracle can shrink or grow datafiles:
ALTER DATABASE DATAFILE '/usr01/oracle/sid/data001' resize 200M;
On Aug 3, 2004, at 15:59, David Griffiths wrote:
Oracle cannot shrink datafiles (same idea as InnoDB datafiles) when
data is deleted either.
David
Marc Slemko wrote:
On Tue, 3 Aug 2004
Oracle cannot shrink datafiles (same idea as InnoDB datafiles) when data
is deleted either.
David
Marc Slemko wrote:
On Tue, 3 Aug 2004 12:42:03 -0400 , David Seltzer <[EMAIL PROTECTED]> wrote:
Thanks Marc,
Is there really no way to reclaim unused space in an InnoDB table space? If
not, why is
On Tue, Aug 03, 2004 at 01:08:58PM -0400, [EMAIL PROTECTED] wrote:
>
> I agree with David. If there is no present way to recover unused
> InnoDB tablespace, then we (as a community) seriously need to create
> a tool to do just that. How have we gone so long without it?
Because it's just not a pro
gt;
>>
>>>Thanks Marc,
>>>
>>>Is there really no way to reclaim unused space in an InnoDB table
>>> space?
>>
>> If
>>
>>>not, why is this not considered a tremendous limitation?
>>>
>>>-Dave Seltzer
>>>
>
PM
To: David Seltzer
Cc: [EMAIL PROTECTED]
Subject: Re: InnoDB TableSpace Question
On Tue, 3 Aug 2004 10:07:25 -0400 , David Seltzer <[EMAIL PROTECTED]>
wrote:
Hi all,
I've been searching the archives & mysql documentation for a while and
I
can't seem to find an answer to my qu
:09 PM
To: David Seltzer
Cc: [EMAIL PROTECTED]
Subject: RE: InnoDB TableSpace Question
I agree with David. If there is no present way to recover unused InnoDB
tablespace, then we (as a community) seriously need to create a tool to do
just that. How have we gone so long without it? I always
From: Marc Slemko [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 03, 2004 12:31 PM
> To: David Seltzer
> Cc: [EMAIL PROTECTED]
> Subject: Re: InnoDB TableSpace Question
>
> On Tue, 3 Aug 2004 10:07:25 -0400 , David Seltzer <[EMAIL PROTECTED]>
> wrote:
> > Hi all,
>
On Tue, 3 Aug 2004 12:42:03 -0400 , David Seltzer <[EMAIL PROTECTED]> wrote:
> Thanks Marc,
>
> Is there really no way to reclaim unused space in an InnoDB table space? If
> not, why is this not considered a tremendous limitation?
Some do consider it a tremendous limitation. It all depends on ho
: [EMAIL PROTECTED]
Subject: Re: InnoDB TableSpace Question
On Tue, 3 Aug 2004 10:07:25 -0400 , David Seltzer <[EMAIL PROTECTED]>
wrote:
> Hi all,
>
> I've been searching the archives & mysql documentation for a while and I
> can't seem to find an answer to my questio
On Tue, 3 Aug 2004 10:07:25 -0400 , David Seltzer <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I've been searching the archives & mysql documentation for a while and I
> can't seem to find an answer to my question -
>
> Is there a way to force InnoDB to shrink its filesize? I just dropped a 7GB
> tab
14 matches
Mail list logo
