distal-attribute
distal-attribute
distal-attribute
distal-attribute

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

User, date Message
Written by Akkira
3 months ago
Category: General
1 posts since Fri, 10 Jan 14
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!
Written by jfalchMoney, Euro
3 months ago
352 posts since Sat, 17 Oct 09
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.