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.