How to Reclaim Unused Space or Decrease Size of InnoDB Data File? ibdata1; .ibd
Last updated on MAY 17, 2017
Applies to:MySQL Server - Version 4.1 and later
Information in this document applies to any platform.
Sometimes the size of InnoDB data files - the system tablespace file (ibdata) or table space files (*.ibd) - are bigger than necessary. You may delete many rows from a table and notice the file size does not decrease. The goal is to reclaim that disk space.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms