Re: ibdata size
"Daniel da Veiga" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
On 6/7/06, Urcid Pliego, Paulo <[email protected]> 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/[email protected]