List:General Discussion« Previous MessageNext Message »
From:Antonio Fernández Pérez Date:June 24 2014 11:03am
Subject:Optimizing InnoDB tables
View as plain text  
​Hi list,

I was trying to optimize the InnoDB tables. I have executed the next query
to detect what are the fragmented tables.

​​SELECT TABLE_SCHEMA,TABLE_NAME
FROM TABLES WHERE TABLE_SCHEMA NOT IN ("information_schema","mysql") AND
Data_free > 0​

After that, I have seen that there are 49 fragmented tables. With one
table, I have executed "optimize table table_name;" and "analyze table
table_name;". The result is the same, the table continuos fragmented.

Any ideas? I have followed the mysqltuner recomendations ...

Thanks in advance.

Regards,

Antonio.

Thread
Optimizing InnoDB tablesAntonio Fernández Pérez24 Jun 2014
  • Re: Optimizing InnoDB tablesWagner Bianchi24 Jun 2014
    • Re: Optimizing InnoDB tablesAntonio Fernández Pérez24 Jun 2014
  • Re: Optimizing InnoDB tablesshawn l.green24 Jun 2014
    • Re: Optimizing InnoDB tablesReindl Harald24 Jun 2014
      • Re: Optimizing InnoDB tablesshawn l.green24 Jun 2014
        • Re: Optimizing InnoDB tablesAntonio Fernández Pérez25 Jun 2014
          • Re: Optimizing InnoDB tablesJohan De Meersman25 Jun 2014
          • Re: Optimizing InnoDB tablesAndre Matos25 Jun 2014
            • Re: Optimizing InnoDB tablesAntonio Fernández Pérez27 Jun 2014
              • Re: Optimizing InnoDB tablesReindl Harald27 Jun 2014
                • Re: Optimizing InnoDB tablesAntonio Fernández Pérez27 Jun 2014
                  • Re: Optimizing InnoDB tablesshawn l.green27 Jun 2014
                  • Re: Optimizing InnoDB tablesJohan De Meersman27 Jun 2014
                    • Re: Optimizing InnoDB tablesAntonio Fernández Pérez30 Jun 2014
                      • Re: Optimizing InnoDB tablesReindl Harald30 Jun 2014