Hi, I have MySQL Server Enterprise 5.5 Percona with Innodb. I have observed that I have several tables with a high level of fragmentation. What tool or command do you recommend to use to defragment the tables?
@gar1212
Either you can user alter command.
alter table table_name engine=innodb;
or
you can use pt-online-schema-change¶
https://www.percona.com/doc/percona-toolkit/3.0/index.html
Note: ensure you read the document carefully.
Tip: ensure you have PK
Hope this helps…