13 messages in com.mysql.lists.mysqlRe: Can Innodb reuse the deleted rows...
FromSent OnAttachments
leo huang23 Jul 2006 22:56 
dili...@sifycorp.com23 Jul 2006 23:51 
leo huang25 Jul 2006 19:47 
Chris25 Jul 2006 20:04 
leo huang26 Jul 2006 01:45 
Chris26 Jul 2006 18:29 
leo huang28 Jul 2006 00:55 
Chris28 Jul 2006 01:01 
leo huang28 Jul 2006 01:08 
Dan Nelson28 Jul 2006 09:41 
Jochem van Dieten29 Jul 2006 07:07 
Dan Nelson29 Jul 2006 13:57 
leo huang01 Aug 2006 02:56 
Subject:Re: Can Innodb reuse the deleted rows disk space?
From:Chris (dmag@gmail.com)
Date:07/28/2006 01:01:59 AM
List:com.mysql.lists.mysql

leo huang wrote:

hi, Chris

I'm sure it will, what makes you think it won't?

Because some paper say that when the row is deleted or update, Innodb just make a mark that the row is deleted and it didn't delete the rows. I can't find more information about the re-use tablespace. Can you give me more?

That's the way MVCC works. If you need full acid/transaction support, that's the only way it can do it (postgresql works exactly the same way). It can't just delete the row because you might roll back the transaction and it will have to undo that delete, or other transactions might be using it for whatever purpose.

http://dev.mysql.com/doc/refman/5.1/en/innodb-multi-versioning.html http://dev.mysql.com/doc/refman/5.1/en/file-space-management.html