Hello,
I understand that with that pt-online-schema-change tool you can optimize your mysql table, but I used it with one table after deleting colums from this table, but I don’t won any free space…
The table has 41G space and deleting columns I had calculated gain 11G space, but using this tool I still with 41G…
This is the command that I used:
pt-online-schema-change --alter “ENGINE=InnoDB” D=my_database,t=mytable --max-lag=30000 Threads_running=100 --execute
More información:
I’m using Percona-server-5.5
Any suggestion?
Thank you!