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.
table sizes not updating
You are aware if the roughly estimated table size for InnoDB tables?
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?
This has nothing to do with HeidiSQL, it's just how InnoDB works. HeidiSQL cannot grab a value that the server doesn't provide.
Aw, thanks. Did not realize that.
Please login to leave a reply, or register at first.