table sizes not updating

dmikester1's profile image dmikester1 posted 7 years ago in General Permalink

Anyone know why my table sizes don't update at all? I am using MySQL. I can delete 90% of the rows in a table that that file size to the right of the table name doesn't change at all. I refreshed it multiple times. I know another table has been stuck at the same large file size for a long time as well, so I just assume all of them are not updating.

ansgar's profile image ansgar posted 7 years ago Permalink

You are aware if the roughly estimated table size for InnoDB tables?

dmikester1's profile image dmikester1 posted 7 years ago Permalink

Those sizes next to the table name are rough estimates you are saying? That is fine with me, but I would think when I delete 90% of the table that size should update, shouldn't it?

kalvaro's profile image kalvaro posted 7 years ago Permalink

This has nothing to do with HeidiSQL, it's just how InnoDB works. HeidiSQL cannot grab a value that the server doesn't provide.

dmikester1's profile image dmikester1 posted 7 years ago Permalink

Aw, thanks. Did not realize that.

Please login to leave a reply, or register at first.