From: Kay [DAS] Rozeboom Date: November 1 2011 2:02pm Subject: Reusing "ibdata1" space List-Archive: http://lists.mysql.com/mysql/226211 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_000_BFE615A1BBF8CA40B016B28E1BABC6240FF822BE98iowadsmex104i_" --_000_BFE615A1BBF8CA40B016B28E1BABC6240FF822BE98iowadsmex104i_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable We are running MySQL 5.0.77, and using INNODB in production for the first t= ime. The production database has a lot of inserts and deletes, and the sha= red "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 follo= wing instead: 1) Let "ibdata1" grow for a while. 2) Rebuild the tables periodically using this syntax: ALTER TABLE t1= ENGINE =3D InnoDB; I realize that this would not return the unused space to the operating syst= em. But would it return it to MySQL so that it could be re-used for subseq= uent 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 --_000_BFE615A1BBF8CA40B016B28E1BABC6240FF822BE98iowadsmex104i_--