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/[EMAIL PROTECTED]
