ibdata size
------_=_NextPart_001_01C68A51.C82AE038
Content-Type: text/plain;
charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi everyone!
We have an InnoDB database with its respective ibdata file. As you =
probably
know, the ibdata has a fixed initial size and may grow as more data is
stored in the database. Curiously, when we delete data from the =
database,
the size of the ibdata doesn't get smaller. I have searched forums and =
the
mysql web site and found that this is not a bug, its just that InnoDB =
was
designed that way. So, when we are about to run out of disk space, we =
have
to dump the current data, erase the partition where the ibdata files =
are,
recreate them with a smaller size, and finally load the dump back in. =
Has
anyone encountered this situation? Does anyone have a different =
approach to
this? I welcome any feedback!! Thanks for your time
Paulo Urcid Pliego
E-Labor Producci=F3n DM e IM
Preserie y Construcci=F3n de Equipos
Volkswagen de M=E9xico S.A. de C.V.
Tel=E9fono +52 (222) 2 30 9961
Fax +52 (222) 2 30 6082
<mailto:urcid [at] vw.com.mx> mailto:urcid [at] vw.com.mx
<http://www.vw.com.mx/> http://www.vw.com.mx
------_=_NextPart_001_01C68A51.C82AE038--
Re: ibdata size
On 6/7/06, Urcid Pliego, Paulo <paulo.urcid [at] vw.com.mx> wrote:
> Hi everyone!
>
>
>
> We have an InnoDB database with its respective ibdata file. As you probably
> know, the ibdata has a fixed initial size and may grow as more data is
> stored in the database. Curiously, when we delete data from the database,
> the size of the ibdata doesn't get smaller. I have searched forums and the
> mysql web site and found that this is not a bug, its just that InnoDB was
> designed that way. So, when we are about to run out of disk space, we have
> to dump the current data, erase the partition where the ibdata files are,
> recreate them with a smaller size, and finally load the dump back in. Has
> anyone encountered this situation? Does anyone have a different approach to
> this? I welcome any feedback!! Thanks for your time
>
If you search the archives of this list, this problem has been
discussed many times, AFAIK there's no other way to get the file to
shrink besides dumping it, drop the database, recreate and load the
dump back. Maybe there were more approuches to this, I only use
myisam, so, not sure.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32 [at] m.gmane.org
RE: ibdata size
In case of MYISAM tables, we do OPTIMIZE table after deletion of records =
from a particular table. This will free up the disk space for that =
particular table.
I hope the same case might work for innodb tables.
Ila.
-----Original Message-----
From: Urcid Pliego, Paulo [mailto:paulo.urcid [at] vw.com.mx]
Sent: Wednesday, June 07, 2006 9:45 AM
To: win32 [at] lists.mysql.com
Subject: ibdata size
Hi everyone!
We have an InnoDB database with its respective ibdata file. As you =
probably
know, the ibdata has a fixed initial size and may grow as more data is
stored in the database. Curiously, when we delete data from the =
database,
the size of the ibdata doesn't get smaller. I have searched forums and =
the
mysql web site and found that this is not a bug, its just that InnoDB =
was
designed that way. So, when we are about to run out of disk space, we =
have
to dump the current data, erase the partition where the ibdata files =
are,
recreate them with a smaller size, and finally load the dump back in. =
Has
anyone encountered this situation? Does anyone have a different approach =
to
this? I welcome any feedback!! Thanks for your time
Paulo Urcid Pliego
E-Labor Producci=F3n DM e IM
Preserie y Construcci=F3n de Equipos
Volkswagen de M=E9xico S.A. de C.V.
Tel=E9fono +52 (222) 2 30 9961
Fax +52 (222) 2 30 6082
<mailto:urcid [at] vw.com.mx> mailto:urcid [at] vw.com.mx
<http://www.vw.com.mx/> http://www.vw.com.mx
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32 [at] m.gmane.org
RE: ibdata size
Yes, OPTIMIZE works on InnoDB, however post v4.1.3 it's been mapped to
ALTER TABLE. It's in the documentation and very easy to find. Cheers.
Armando
-------------------------
In case of MYISAM tables, we do OPTIMIZE table after deletion of records
from a particular
table. This will free up the disk space for that particular table.
I hope the same case might work for innodb tables.
Ila.
-----Original Message-----
From: Urcid Pliego, Paulo [mailto:paulo.urcid [at] stripped]
Sent: Wednesday, June 07, 2006 9:45 AM
To: win32 [at] stripped
Subject: ibdata size
Hi everyone!
We have an InnoDB database with its respective ibdata file. As you probably
know, the ibdata has a fixed initial size and may grow as more data is
stored in the database. Curiously, when we delete data from the database,
the size of the ibdata doesn't get smaller. I have searched forums and the
mysql web site and found that this is not a bug, its just that InnoDB was
designed that way. So, when we are about to run out of disk space, we have
to dump the current data, erase the partition where the ibdata files are,
recreate them with a smaller size, and finally load the dump back in. Has
anyone encountered this situation? Does anyone have a different approach to
this? I welcome any feedback!! Thanks for your time
Paulo Urcid Pliego
E-Labor Producción DM e IM
Preserie y Construcción de Equipos
Volkswagen de México S.A. de C.V.
Teléfono +52 (222) 2 30 9961
Fax +52 (222) 2 30 6082
<mailto:urcid [at] stripped> mailto:urcid [at] stripped
<http://www.vw.com.mx/> http://www.vw.com.mx
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32 [at] m.gmane.org
