Make phpMyAdmin show exact number of records for InnoDB tables?

Question

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

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.

How can I do this?

Answer 1

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

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

Just add this line in config.inc.php:

$cfg['MaxExactCount'] = 2000000;

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

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