Re: Can Innodb reuse the deleted rows disk space?

[leo huang]

hi, Dan Nelson, Jochem van Dieten, and Chris

Thx!

I think I understand it after your replies.

Regards,
Leo Huang

2006/7/30, Dan Nelson <dnelson@stripped>:
> In the last episode (Jul 29), Jochem van Dieten said:
> > 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.
>
> Ouch.
>
> --
>         Dan Nelson
>         dnelson@stripped
>