From: Dan Nelson
Date: July 29 2006 8:57pm
Subject: Re: Can Innodb reuse the deleted rows disk space?
List-Archive: http://lists.mysql.com/mysql/200416
Message-Id: <20060729205734.GA63872@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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