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 <[EMAIL PROTECTED]>:
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 [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]