Re: Can Innodb reuse the deleted rows disk space?

[Dan Nelson]

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