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
signature.asc
Description: OpenPGP digital signature
