List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:November 1 2011 2:09pm
Subject:Re: Reusing "ibdata1" space
View as plain text  
Am 01.11.2011 15:02, schrieb Rozeboom, Kay [DAS]:
> 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;

this will not help as long you are not using "innodb_file_per_table"
and if you would using it "ibdata1" would not grow

in my opinion "innodb_file_per_table=0" is a dumb default and
requires that people with too few expierience with mysql/innodb
would much more carefully read documentations as they usually do

Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
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