Re: Optimizing InnoDB tables

2014-06-27 Thread Johan De Meersman
- Original Message - > From: "Antonio Fernández Pérez" > Subject: Re: Optimizing InnoDB tables > > I would like to know, if is possible, why after execute an analyze table > command on some fragmented table, after that, appears fragmented again. Simple question: why do you believe this i

Re: Optimizing InnoDB tables

2014-06-27 Thread shawn l.green
Hello Antonio, On 6/27/2014 9:31 AM, Antonio Fernández Pérez wrote: ​Hi Reindl, Thanks for your attention. Following the previous mail, I have checked my MySQL's configuration and innodb_file_per_table is enabled so, I think that this parameter not affects directly to fragmented tables in Inno

Re: Optimizing InnoDB tables

2014-06-27 Thread Antonio Fernández Pérez
​Hi Reindl, Thanks for your attention. Following the previous mail, I have checked my MySQL's configuration and innodb_file_per_table is enabled so, I think that this parameter not affects directly to fragmented tables in InnoDB (In this case). I would like to know, if is possible, why after exec

Re: Optimizing InnoDB tables

2014-06-27 Thread Reindl Harald
Am 27.06.2014 09:48, schrieb Antonio Fernández Pérez: > Thanks for your reply. I have checked the link and my configuration. > Innodb_file_per_table is enabled and in data directory appears a set of > files by each table. > > Any ideas? ideas for what? * which files don't get shrinked (ls -lha)

Re: Optimizing InnoDB tables

2014-06-27 Thread Antonio Fernández Pérez
​Hi Andre, Thanks for your reply. I have checked the link and my configuration. Innodb_file_per_table is enabled and in data directory appears a set of files by each table. Any ideas? Thanks in advance. Regards, Antonio.​