List:General Discussion« Previous MessageNext Message »
From:Kay [DAS] Rozeboom Date:November 1 2011 2:02pm
Subject:Reusing "ibdata1" space
View as plain text  
We are running MySQL 5.0.77, and using INNODB in production for the first time.  The
production database has a lot of inserts and deletes, and the shared "ibdata1" file is
continually growing.  I understand that to return the unused space to the operating
system, we must delete and recreate "ibdata1" and its associated ".frm" files.  I am
wondering if we could do the following instead:

1)      Let "ibdata1" grow for a while.
2)      Rebuild the tables periodically using this syntax:   ALTER TABLE t1 ENGINE =
InnoDB;

I realize that this would not return the unused space to the operating system.  But would
it return it to MySQL so that it could be re-used for subsequent inserts, instead of
extending "ibdata1" further?

Kay Rozeboom
Information Technology Enterprise
Iowa Department of Administrative Services
Telephone: 515.281.6139   Fax: 515.281.6137
Email:  Kay.Rozeboom@stripped




Thread
Reusing "ibdata1" spaceKay [DAS] Rozeboom1 Nov
  • Re: Reusing "ibdata1" spaceReindl Harald1 Nov
    • Re: Reusing "ibdata1" spaceNick Khamis9 Nov
      • Re: Reusing "ibdata1" spaceJohan De Meersman10 Nov
        • Re: Reusing "ibdata1" spacePrabhat Kumar10 Nov
          • Re: Reusing "ibdata1" spaceJohan De Meersman10 Nov
    • Re: Reusing "ibdata1" spaceNick Khamis9 Nov
  • Re: Reusing "ibdata1" spaceClaudio Nanni1 Nov
  • Re: Reusing "ibdata1" spaceJohan De Meersman1 Nov
    • RE: Reusing "ibdata1" spaceKay [DAS] Rozeboom22 Nov