Not the answer you need?
Register and ask your own question!

pt-online-schema-change has not optimized my mysql table

AbdelbassitAbdelbassit EntrantCurrent User Role Beginner

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!


  • pintu_ag23pintu_ag23 Contributor Current User Role Beginner
    did u check the free space from information_schema.tables table?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.