----- Original Message -----
> From: "Kay Rozeboom [DAS]" <KAY.ROZEBOOM@stripped>
>
> 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
