Am 11.01.2012 16:15, schrieb drsystems@stripped:
> I read in
> that using the innodb_file_per_table will help to reclaim space when a
> mysql database grows too large, even though actual data has been deleted
> from it. I am using mysql/innodb with dbmail and need to find a better way
> to manage disk space.
> My question is: will the command OPTIMIZE TABLE actually shrink the .idb
yes, ONLY with "innodb_file_per_table"
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc