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
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 been able
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,
Is there really no way to reclaim unused
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 specify
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 ... resize
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,
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
table, but
: [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 question -
Is there a way to force InnoDB
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 how it
: 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,
I've been searching the archives mysql documentation for a while and
I
can't seem
: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
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 question -
Is there a way to force
: 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,
I've been searching the archives mysql documentation for a while
and
I
can't seem to find
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
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
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
16 matches
Mail list logo