Reputation
Next privilege 125 Rep.
Vote down
Badges
0 0 0
Impact
0 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
May
28
comment How do MyISAM and InnoDB Utilize HD Space?
@RolandoMySQLDBA. I've found that the data size, index size and free space columns don't always match the size of the table's .idb file. I've found the sum of these columns is almost always smaller than the the actual .idb file -- up to 33% smaller. Is there another column that I'm missing? Looking at your query above I see that you're only using data size and index size.