From: Johan De Meersman Date: November 1 2011 3:00pm Subject: Re: Reusing "ibdata1" space List-Archive: http://lists.mysql.com/mysql/226214 Message-Id: <77a4d926-4523-4293-8ac9-561b60a79deb@zimbra> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Kay Rozeboom [DAS]" > > 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? That should normally already happen. An occasional optimize table might help defragment the tablespace, but space from properly deleted records should be reused anyway (save for really small fragments). I recommend you keep track of the innodb free tablespace for a while, and see how that evolves - it should go relatively low before the tablespace expands on disk. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel