#4027 (ok 4.2.6) $cfg['MaxExactCount'] is ignored when BROWSING is back

[Eichl]

Hi,

I have a problem with phpmyadmin version 4.0.4.1
We have some very large innodb tables (more than 750 mio rows)
If I click on this large table in phpmyadmin only a orange window with "Loading" is shown.
In the background a SELECT COUNT( * ) FROM TABLE is running and never comes back.
I found a old bug with title "$cfg['MaxExactCount'] is ignored when BROWSING".
But this bug is fixed since years.

http://sourceforge.net/p/phpmyadmin/bugs/865/

I tried to set MaxExactCount to different values but nothing seems to fix the problem.

Regards
Eichl

[Marc Delisle]

Could you tell me if this commit could be the culprit?
https://github.com/phpmyadmin/phpmyadmin/commit/f5d631db

And which MySQL version are you using?

[Eichl]

We are using.

Software version:
5.5.8-enterprise-commercial-advanced-log - MySQL Enterprise Server - Advanced Edition (Commercial)

and
Database client version:
libmysql - 5.1.66

I will try the fix in the comment immediately.

[Marc Delisle]

To be more exact, I'm asking you to remove the fix done in the commit I referenced.

[Eichl]

hi,

that seems to fix the problem.

[Marc Delisle]

The situation was discussed here: https://sourceforge.net/p/phpmyadmin/mailman/phpmyadmin-devel/thread/51F6495D.7000107%40infomarc.info/#msg31227039 but we still have to decide about it.

[Sergey Solozhentsev]

I have the same issue in 4.0.9. I've attache config

[Marc Delisle]

Sergey,
how many rows are there in your table, and which MySQL version are you using?

[Sergey Solozhentsev]

There are about 20 million rows. I use percona 5.6

[Marc Delisle]

Sergey,
if you remove this patch:
https://github.com/phpmyadmin/phpmyadmin/commit/f5d631db

does it fix the problem for you too?

[Brad Dwyer]

I can confirm that I am also having this issue. I was unable to find the line you referenced in version 4.1.3, but I can confirm that forcing $force_exact = false in PMA_Table::countRecords (libraries/Table.class.php) "fixed" things for me.

Relevant stackoverflow topic: http://stackoverflow.com/questions/20912758/phpmyadmin-hangs-server-by-doing-a-count-when-going-to-browse

[Eichl]

Hi,

I updated a phpmyadmin test instance to version 4.1.9. force_exact in libraries/Table.class.php is set to false.

572 static public function countRecords($db, $table, $force_exact = false,
573 $is_view = null
574 ) {

But this doesn't seem to fix the problem anymore.

What have I to do to fix this problem again?

[Eichl]

Bug is still present in 4.2.2. Could you please provide me with information how to fix that?

[Marc Delisle]

@Eichl,
I have an idea why you could not fix this. You are showing us the place where the countRecords() function is defined. In the definition, we see that the default value of $force_exact is set to false. However, this is not enough to change the behavior. For version 4.2.2, try this: in libraries/sql.lib.php, function PMA_countQueryResults(), you'll see a call to PMA_Table::countRecords() in which the third parameter is "true". Change it to false and retest.

[Eichl]

Hi Marc,

the problem seems to be fixed again.

Thank you very much.

regards
Steffen

[Marc Delisle]

Hi Steffen,
do you mean that changing the value to "false" as I indicated in my previous message, worked for you?

Note that we don't have yet a complete solution for this, as changing the value to false has side effects.

[Eichl]

Hi Marc,

correct. Setting the value to false, works for me.

[Marc Delisle]

Hopefully fixed with https://github.com/phpmyadmin/phpmyadmin/commit/3f21378e4c5aff430ef23bbaefa6967d5dac89c4.patch and the target is version 4.2.6. However, I would really, really appreciate your testing and comments.

[Eichl]

Hi,

the problem is fixed in version 4.2.6 .

Thank you.

regards
Eichl