使phpMyAdmin显示InnoDB表的确切记录数?

问题描述

有什么方法可以使phpMyAdmin显示InnoDB表的确切记录数?

Is there any way to make phpMyAdmin show exact number of records for InnoDB tables?

我知道为什么InnoDB基于解释的记录有不同个记录，因为它是一个事务引擎，但是SQLBuddy显示了InnoDB表的确切记录数，所以我认为phpMyAdmin有一种方法一样.

I know why InnoDB has different number of records based on interpretation because it's a transactional engine but SQLBuddy is showing the exact number of records for InnoDB tables so I think there is a way for phpMyAdmin to do the same.

我该怎么做?

推荐答案

在此线程上找到答案:

Just found the answer on this thread: PHPMyAdmin - Total record count varies

似乎在config.inc.php中添加配置参数可以解决问题: http://www.kavoir.com/2012/07/make-phpmyadmin-show-exact-number-of-records-for-innodb-tables. html

Seems adding a configuration parameter in config.inc.php does the trick: http://www.kavoir.com/2012/07/make-phpmyadmin-show-exact-number-of-records-for-innodb-tables.html

只需在config.inc.php中添加以下行:

Just add this line in config.inc.php:

$cfg['MaxExactCount'] = 2000000;

因此，任何少于2000000行的InnoDB表都将显示确切的行数.

So that any InnoDB table with less than 2000000 rows will have an exact number of rows displayed.

使此数字足够大，数据库中的所有InnoDB表在phpMyAdmin数据库页面上将具有确切的行数.

Make this number large enough and all InnoDB tables in your database will have an exact number of rows on phpMyAdmin database page.

这篇关于使phpMyAdmin显示InnoDB表的确切记录数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！