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?
why this behaviour?
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.
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.
Please login to leave a reply, or register at first.