different spindle or set of spindles as your
data file.
-Original Message-
From: Dave Juntgen [mailto:[EMAIL PROTECTED]
Sent: Monday, December 06, 2004 6:30 AM
To: [EMAIL PROTECTED]
Subject: InnoDB tablespace Question.
Hello!
I have what seems to be a trivial question, but have not
Hello!
I have what seems to be a trivial question, but have not been able to
find a definite answer and your help would be greatly appreciated.
Question:
When creating InnoDB table spaces, are there any advantages to using
multi table spaces for each table or is it better to create a few larg
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
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
table, but it hasn't freed up the disk space and I need it back. From what
I've been reading,
16 matches
Mail list logo
