phpMyAdmin没有显示所有行-显示的总记录数错误 [英] phpMyAdmin not showing all rows - wrong number of total records shown

问题描述

我在phpMyAdmin v4.3.2中显示了mysql innodb表的所有行(825)，该表按默认的自动增量主键排序.当升序排序时，我转到最后一页，但当它的id = 1337时它将在id = 1150处停止.最后200条左右的记录不会显示.按降序排列时，记录正确地从最后一条记录开始.

I'm showing all rows (825) in phpMyAdmin v4.3.2 for a mysql innodb table sorted by the default autoincrement primary key. When sorted ascending, I go to the last page but it stops at id = 1150 when it should be id = 1337. The last 200 or so records do not display. When sorted descending, the records correctly start at the last record.

奇怪的是，增加每页的行数会得到更多的丢失行，如果我将其设置为每页250行，它们将全部存在.

Oddly, increasing the number of rows per page give more of the missing rows and if I set it to 250 rows per page, they will all be there.

有什么想法为什么结果集会被截断?似乎phpMyAdmin错误地计算了页数.

Any ideas why the result set is truncated? It seems as if phpMyAdmin is miscalculating number of pages.

更新 我已升级到最新版本4.5.0.2，问题仍然存在.

UPDATE I upgraded to the latest version 4.5.0.2 and the problem persists.

UPDATE2 输入表时执行的查询为SELECT * FROM gems 结果:显示0-24行(总共825行，查询花费了0.0000秒.)

UPDATE2 The query executed when entering the table is SELECT * FROM gems The result: Showing rows 0 - 24 (825 total, Query took 0.0000 seconds.)

当我执行查询select count(*) from gems时，结果返回997.因此，问题显然出在phpMyAdmin认为存在的估计记录数中.

When I do the query select count(*) from gems the result returns 997. So the problem is clearly in the estimated number of records phpMyAdmin thinks is there.

推荐答案

我发现我的phpMyAdmin配置文件中粘贴了以下设置，这些设置是由谁知道我以前做过哪些性能修复的人粘贴的.

I found that I had the following setting in my phpMyAdmin config file pasted from who know what previous performance fix I made.

$cfg['MaxExactCount'] = 0

这禁止更正InnoDB估计值.我注释了这一行，当然可以解决问题

This disabled correcting InnoDB estimates. I commented out this line, and of course it took care of the problem

这篇关于phpMyAdmin没有显示所有行-显示的总记录数错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！