MySQL InnoDB not releasing disk space after deleting data rows from table

by

MySQL doesn’t reduce the size of ibdata1. Ever. Even if you use optimize table to free the space used from deleted records, it will reuse it later.

An alternative is to configure the server to use innodb_file_per_table, but this will require a backup, drop database and restore. The positive side is that the .ibd file for the table is reduced after an optimize table.

More Related Contents:

  1. MyISAM versus InnoDB [closed]
  2. How to debug Lock wait timeout exceeded on MySQL?
  3. Is there a REAL performance difference between INT and VARCHAR primary keys?
  4. MySQL AUTO_INCREMENT does not ROLLBACK
  5. 1114 (HY000): The table is full
  6. How to shrink/purge ibdata1 file in MySQL
  7. Restore table structure from frm and ibd files
  8. What’s the difference between MyISAM and InnoDB? [duplicate]
  9. Why is MySQL InnoDB insert so slow?
  10. Deleting rows with MySQL LEFT JOIN
  11. MySql: MyISAM vs. Inno DB! [closed]
  12. Prevent auto increment on MySQL duplicate insert
  13. UUID performance in MySQL?
  14. SQL DELETE with JOIN another table for WHERE condition
  15. Force InnoDB to recheck foreign keys on a table/tables?
  16. What is MySQL’s default ON DELETE behavior?
  17. Is there any performance gain in indexing a boolean field?
  18. Why does MySQL autoincrement increase on failed inserts?
  19. How can I check MySQL engine type for a specific table?
  20. MySQL InnoDB: autoincrement non-primary key
  21. How do I rename a MySQL database (change schema name)?
  22. How to regex in a MySQL query
  23. MySQL Integer vs DateTime index
  24. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  25. How do I lock on an InnoDB row that doesn’t exist yet?
  26. Defining Composite Key with Auto Increment in MySQL
  27. MySQL DROP all tables, ignoring foreign keys
  28. “Unknown column in ‘field list'”, but column does exist
  29. Should I always prefer MySQL InnoDB over MyISAM?
  30. How can I rebuild indexes and update stats in MySQL innoDB?

Leave a Comment