Lawrence,
- Alkuperäinen viesti -
Lähettäjä: "Lawrence Smith" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Sunday, February 01, 2004 1:03 PM
Aihe: Re: Shrinking innodb datafiles?
--- Heikki Tuuri <[EMAIL PROTECTED]> wrote: >
> >
> > Just to confirm if I understand the situation
> > correctly: innodb datafiles cannot be reduced in
> size
> > to reclaim spaced freed by deleted data?
>
> you are right.
Once again thanks. One absolutely last question (only
just occurred to
Lawrence,
- Original Message -
From: "Lawrence Smith" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, January 31, 2004 6:47 PM
Subject: Re: Shrinking innodb datafiles?
> Heikki,
>
> thank
Heikki,
thanks for the reply, will note.
Just to confirm if I understand the situation
correctly: innodb datafiles cannot be reduced in size
to reclaim spaced freed by deleted data? (That'd
probably explain why I had a hard time finding ISPs
offering innodb-enabled MySQL).
Lawrence Smith
---
dbc
Sent: Friday, January 30, 2004 12:59 AM
Subject: Re: Shrinking innodb datafiles?
> --- Jeff Mathis <[EMAIL PROTECTED]> wrote: >
> someone will no doubt echo what I'm about to say.
> > InnoDB files are created at startup. the files use
> > all the disk you
--- Jeff Mathis <[EMAIL PROTECTED]> wrote: >
someone will no doubt echo what I'm about to say.
> InnoDB files are created at startup. the files use
> all the disk you
> allocate to them in your my.cnf startup file.
>
> If you want smaller InnoDB files, specify a smaller
> file size in your
> my
someone will no doubt echo what I'm about to say.
InnoDB files are created at startup. the files use all the disk you
allocate to them in your my.cnf startup file.
If you want smaller InnoDB files, specify a smaller file size in your
my.cnf file, but I have a feeling thats not what you want to d
I have recently dropped a database with a big innodb
table in it - but the data file (ibdata1) failed to
get smaller. It's pretty big (nearly 2GB) and I'd like
to
reduce it if possible. Is there any way to do this?
Thx
BT
