wrong table size (too small) & wrong row count (too many) displayed in HeidiSQL?

[expired user #7552]'s profile image [expired user #7552] posted 10 years ago in General Permalink
I am saving thousands of images in a mysql innodb database.
select count(*) from imagelist gives 3976 (which is how many images are inside now), when the data view tells me I have 89560 lines!
In the bar on the left the table size is 83 mb, when the folder on the disk is 800 mb.

It's probably some sort of misunderstanding on my side, please enlighten me!
jfalch's profile image jfalch posted 10 years ago Permalink
innodb size and record count in data view is always approximate. sometimes wrong (and even wildly, as in your case), but much faster.

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