PHPMyAdmin - 总记录数不同 [英] PHPMyAdmin - Total record count varies
问题描述
我正在使用 phpmyadmin 对记录表运行请求,结果计数各不相同.例如,当显示结果时,它会显示显示记录 1 - (~180,234 )".
每次刷新时此数字都会更改,并且不会添加或删除任何数据.
当我对记录执行 SQL 请求时,结果保持不变.这是 phpMyAdmin 的问题吗?
I am running a request on a table of records with phpmyadmin, and the results count varies. For example, when showing the results it says "Showing records 1 - (~180,234 )".
This number changes each time I refresh, and no data is being added or removed.
When I do a SQL request for the record, the result stays the same. Is this an issue with phpMyAdmin?
推荐答案
对于 InnoDB 表,来自 phpMyAdmin 的常见问题解答:
For InnoDB tables, from phpMyAdmin's FAQ:
phpMyAdmin 使用快速方法获取行数,只有这个方法返回一个近似计数InnoDB 表的情况.看$cfg['MaxExactCount'] 的方法修改这些结果,但这可能严重影响性能.
phpMyAdmin uses a quick method to get the row count, and this method only returns an approximate count in the case of InnoDB tables. See $cfg['MaxExactCount'] for a way to modify those results, but this could have a serious impact on performance.
http://docs.phpmyadmin.net/en/latest/config.html?highlight=maxexactcount#cfg_MaxExactCount
这篇关于PHPMyAdmin - 总记录数不同的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!