why this behaviour?
| User, date | Message |
|---|---|
|
Written by markzzz
2 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
2 years ago 455 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
2 years ago 10 posts since Mon, 25 Apr 11 |
ah the row count is approximate...ok thanks! :) |
|
Written by Augusto
7 months ago 3 posts since Fri, 30 Nov 12 |
Good to know.. 
|
|
Please login to leave a reply, or register at first. |
