InnoDb Overhead?
Posted
by
Rimary
on Server Fault
See other posts from Server Fault
or by Rimary
Published on 2009-12-13T12:59:46Z
Indexed on
2014/05/26
21:34 UTC
Read the original article
Hit count: 200
I just converted several large tables from MyISAM to InnoDB.
When I view the tables in phpMyAdmin, they are showing a significant amount of overhead (One table has 6.8GB).
Optimizing the tables (which isn't a supported command on InnoDB) has no affect like it does on MyISAM.
Is this a result of InnoDB having the ever growing data file that never returns space even after deletes? If that's the case, I've never seen overhead like this before from other InnoDB tables.
Is there a way to clean this up?
Edit: Here are the things I've tried (with no success):
- Optimize Table
- Reorder table by primary key
- Defragment table
© Server Fault or respective owner