----- Original Message ----- > From: "Kay Rozeboom [DAS]" <kay.rozeb...@iowa.gov> > > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org