List:InnoDB Storage Engine« Previous MessageNext Message »
From:Reindl Harald Date:January 11 2012 4:23pm
Subject:Re: innodb_file_per_table
View as plain text  

Am 11.01.2012 16:15, schrieb drsystems@stripped:
> Hi,
> 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
> file?

yes, ONLY with "innodb_file_per_table"

Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
innodb_file_per_tabledrsystems11 Jan
  • Re: innodb_file_per_tableReindl Harald11 Jan