table sizes not updating

dmikester1 posted 1 year ago in General

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 posted 1 year ago

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

dmikester1 posted 1 year ago

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 posted 1 year ago

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 posted 1 year ago

Aw, thanks. Did not realize that.

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