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

4.0.4
fixed
Marc Delisle
None
1
2014-08-14
2013-07-18
Eichl
No

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

Discussion

  • Marc Delisle
    Marc Delisle
    2013-07-24

    • assigned_to: Marc Delisle
     
  • Eichl
    Eichl
    2013-07-25

    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
    Marc Delisle
    2013-07-25

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

     
  • Marc Delisle
    Marc Delisle
    2013-07-27

    • assigned_to: Marc Delisle --> nobody
     
  • Eichl
    Eichl
    2013-07-29

    hi,

    that seems to fix the problem.

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

     
    Attachments
  • Marc Delisle
    Marc Delisle
    2013-12-09

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

     
  • There are about 20 million rows. I use percona 5.6

     
  • Eichl
    Eichl
    2014-03-14

    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
    Eichl
    2014-05-22

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

     
  • Marc Delisle
    Marc Delisle
    2014-05-26

    @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
    Eichl
    2014-06-05

    Hi Marc,

    the problem seems to be fixed again.

    Thank you very much.

    regards
    Steffen

     
  • Marc Delisle
    Marc Delisle
    2014-06-05

    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
    Eichl
    2014-06-05

    Hi Marc,

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

     
  • Marc Delisle
    Marc Delisle
    2014-06-29

    • summary: $cfg['MaxExactCount'] is ignored when BROWSING is back --> (ok 4.2.6) $cfg['MaxExactCount'] is ignored when BROWSING is back
    • assigned_to: Marc Delisle
    • Priority: 5 --> 1
     
  • Marc Delisle
    Marc Delisle
    2014-07-18

    • Status: open --> fixed
     
  • Eichl
    Eichl
    2014-07-25

    Hi,

    the problem is fixed in version 4.2.6 .

    Thank you.

    regards
    Eichl