Thank you guys!!

I have a lot of MyISAM and a lot of InnoDB on this database.

I did one little "for" to run one "OPTIMIZE TABLE" in each table that I
have, on my database.

If this step don't save enough disk space, I'll do the Baron suggestion.

Thank you all!

- Tiago Cruz


On Wed, 2007-10-10 at 15:44 -0300, Eric Frazier wrote:

> He has InnoDB tables and that doesn't reclaim tablespace. He wants to 
> get back disk space from his data files.
> " As of 4.1.3, |OPTIMIZE TABLE| is mapped to |ALTER TABLE|, which 
> rebuilds the table to update index statistics and free unused space in 
> the clustered index"
> But that just means he has empty space in his tablespace :) At least 
> that is how I read it, so Baron's suggestion makes the most sense.



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

Reply via email to