Barry <[EMAIL PROTECTED]> writes: > David Israelsson schrieb: >> I have a really simple (two tables, one relation) but big (~70 GB) >> innodb database containing rather dynamic data. After deleting lots >> of records from the tables, the innodb data files still take the same >> amount of disk space as before. What is the correct way of freeing >> the disk space? >> The general solution seems to be "alter table tablename type=innodb" >> which completely rebuilds the table, but this is not acceptable >> because: >> a) It locks the table during the operation making it unavailable to >> other clients. >> b) It involves copying the table, taking twice the disk space >> during >> the operation - disk space that I do not have. >> Is there another way of doing this? > > Probably OPTIMIZE helps here > I wish I was that lucky. According to the documentation, OPTIMIZE for InnoDB tables is mapped to ALTER TABLE. This is also exactly my experiences after actually trying it.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
