Re: Can Innodb reuse the deleted rows disk space?

[Jochem van Dieten]

On 7/28/06, Dan Nelson wrote:
> In the last episode (Jul 28), leo huang said:
>>
>> So,  the deleted rows' disk space in tablespace can't re-use when I
>> use Innodb, can it? And the tablespace is growing when we update the
>> tables, even the amount of rows do not increase.
>
> It can be re-used after the transaction has been committed

After all transactions that were started before the transaction that
did the delete committed have either been committed or rolled back.

Jochem