Count Rows Error (rev 9.2.0.4976-64bits)

3 posts
[expired user #9085]'s profile image [expired user #9085] posted 9 years ago in General Permalink
See pic
1 attachment(s):
  • count_rows_error
10152 posts
ansgar's profile image ansgar posted 9 years ago Permalink
SHOW TABLE STATUS returns an aproximate row count for InnoDB tables. See here: https://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html
3 posts
[expired user #9085]'s profile image [expired user #9085] posted 9 years ago Permalink
But in PhPMyadmin I see perfect
10152 posts
ansgar's profile image ansgar posted 9 years ago Permalink
Perhaps pma fires a SELECT COUNT(*) on each table. I don't know. But HeidiSQL does not do that, as that is extremely slow in larger tables.
3 posts
[expired user #9085]'s profile image [expired user #9085] posted 9 years ago Permalink
Ok, thanks.
_
Thanks for this awesome piece of Sowtware, every day I dwl the last build .
Thanks
959 posts
kalvaro's profile image kalvaro posted 9 years ago Permalink
PhpMyAdmin has a setting to control that.

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