Why does the number of rows change every time when I refresh the Table Main View?
Apply OS: Windows, macOS, Linux
Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for MariaDB, Navicat Premium
Apply Navicat Version No.: All
MySQL & MariaDB
In the Table Main View, if you have selected Detailed View, the row numbers shown will only be an estimate of the number of records but not the exact one.
This is indeed a property of MySQL InnoDB table, please refer to the MySQL documentation regarding this issue: http://dev.mysql.com/doc/refman/5.1/en/show-table-status.html
The number of rows. Some storage engines, such as MyISAM and ISAM, store the exact count.
For other storage engines, such as InnoDB, this value is an approximation, and may vary from the actual value by as much as 40 to 50%. In such cases, use SELECT COUNT(*) to obtain an accurate count."
The Rows column is just an estimation reflecting the value of "reltuples" in pg_class table but not the exact one.