Optimizing InnoDB tables

[Antonio Fernández Pérez]

​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.