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

why this behaviour?

User, date Message
Written by markzzz
3 years ago
Category: General
10 posts since Mon, 25 Apr 11
When I try to show my tables on HeidiSql (and refresh the database), I notice this (you can see the screenshoot after 3 refresh in few seconds) :

screenshot1
screenshot2
screenshot3

The rows for those tables are different at any refresh! What?
Written by kalvaro
3 years ago
597 posts since Thu, 29 Nov 07
That's because your tables are InnoDB. In such engine, the row count is approximate:

http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html

Scroll down to InnoDB does not keep an internal count of rows in a table.
Written by markzzz
3 years ago
10 posts since Mon, 25 Apr 11
ah the row count is approximate...ok thanks! :)
Written by Augusto
2 years ago
3 posts since Fri, 30 Nov 12
Good to know.. wink
 

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