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

pt-online-schema-change reclaiming InnoDB space

jlcnjlcn EntrantInactive User Role Participant
Hey all,

I'm able to use pt-online-schema-change in order to bring an InnoDB table's size from 6gb to 3gb without a problem. However, the disk space reported using something like df -h shows otherwise -- it sometimes goes up! Even though the table size has been reduced in MySQL.

Any thoughts?

Thanks!

Comments

  • carlos.salguerocarlos.salguero Percona Toolkit Developer Percona Staff Role
    Hello,

    It is hard to answer without having more information.
    Are you deleting the old table? The output of a df -h shows you have less free disk space? in which directory/ies?

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