why this behaviour?

[expired user #5677]'s profile image [expired user #5677] posted 13 years ago in General Permalink
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?
kalvaro's profile image kalvaro posted 13 years ago Permalink
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.
[expired user #5677]'s profile image [expired user #5677] posted 13 years ago Permalink
ah the row count is approximate...ok thanks! :)
[expired user #6700]'s profile image [expired user #6700] posted 11 years ago Permalink
Good to know.. wink

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