 | | | Saving space disk (innodb) | Saving space disk (innodb) 2007-10-10 - By Eric Frazier
Back
Dan Rogart wrote:
> OPTIMIZE TABLE should reclaim that space, but be aware that it could
> take a while to run (locking your table all the while) since it just
> maps to an ALTER TABLE statement which creates a new copy of the table.
> Depends on how big your tables are.
>
> Doc: http://dev.mysql.com/doc/refman/4.1/en/optimize-table.html
>
>
>
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.
Eric
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
|