Hi Antonio, como esta?
What's the mysql version you're running? Have you tried to ALTER TABLE x
ENGINE=InnoDB?
-- WB, MySQL Oracle ACE
> Em 24/06/2014, às 08:03, Antonio Fernández Pérez
> <antoniofernan...@fabergroup.es> escreveu:
>
> 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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
