Re: Can Innodb reuse the deleted rows disk space?

[Chris]

leo huang wrote:
hi, Chris
Thank you for your advice!

I know that Innodb use the logfiles circularly. Can Innodb re-use  the
deleted rows' disk space in tablespace?

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

You might need an 'optimize table' or something to see a reduction in 
the on disk file size but mysql will reclaim that space as it needs to.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]