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
> http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-tablespaces.html
> 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
Thread
innodb_file_per_tabledrsystems11 Jan
  • Re: innodb_file_per_tableReindl Harald11 Jan