#865 (in 2.5.1) $cfg['MaxExactCount'] is ignored when BROWSING
Hi,
the $cfg['MaxExactCount'] is ignored when
I browse through the tables.
Sure, phpmyadmin would prefer to get the
exact row-count because when the estimated row
count is lower than the real-count I may not
be browseable through whole table.
Maybe you can make a further configuration_option
$cfg['MaxExactCountBrowsing']
I am willing to bart the exact results of table-length
by the speed gain (because I know what to do when
this happens). Maybe others do not want this because
they do not know what to do then, when phpma reports
lower estimated table rows than they are in reality
but believe me: on a 4 Gig RAM 2x Xeon4 2.8 GHz
table browsing in innoDB using phpmyadmin with
~5 Mio. Rows is no fun.
How I realized the bug :
Clicking onto the ">" button in the browse-site
gives the result of the next 30 rows in reality
in 17 seconds.
Mysql says: Query took 0.0062 secs.
The rest >16 seconds were obviously (-->show
processlist) used for :
SELECT SQL_CALC_FOUND_ROWS *
FROM `table` LIMIT 1
Maybe you have an idea.
Thank you and best Regards,
Peter
Logged In: YES
user_id=210714
I just made a change in cvs version to use a quick count
(which checks MaxExactCount) when you are "just browsing".
Please test and report.
Logged In: NO
The CVS-Version just gives a blank screen. I also tried to just
repace the probably needed files (sql.php3 and
tbl_properties_structure.php3) resulting in a blank screen, too.
Surprisingly there are no errors in phperr.log.
Logged In: YES
user_id=210714
Just sql.php3 has changed for this. Do you have a blank
screen on every table, or just for the big InnoDB table?
Did you get this version?
http://www.phpmyadmin.net/cvs/
Logged In: NO
I just (10 Mins. ago) downloaded
phpmyadmin.net/cvs/phpMyAdmin-
2.5.1-dev-php.tar.gz and it always gives a blank
screen. The conf-file is correct, I also disabled
php-accelerators. But: phpmyadmin 2.5.0 works
fine at the same time.
So I am unfortunately unable to test your new feature
(MaxExactCount). Shall I try it some days later,
maybe then the "blank-screen-issue" is fixed
in phpmyadmin.
Logged In: YES
user_id=210714
I do not see a blank screen, using the cvs version.
From the FAQ 1.1:
Try to set the $cfg['OBGzip'] directive to FALSE in your
config.inc.php or .php3 file and the zlib.output_compression
directive to Off in your php configuration file.
Logged In: NO
Hi,
its very strage. Here's the summary:
1. I just want to test your code-update in CVS to
see how the new code copes with $cfg['MaxExactCount'].
2. I am running php 4.3.1 as module. Accelerators
deactivated. Apache 1.3.27, 2.4.20 Kernel.
3. phpmyadmin 2.5.0 works.
4. phpmyadmin CVS does not work. A blank white screen
shows up.
5. Nothing in php_error.log
6. gzip & co. deactivated (although supported)
7. When I comment out include(common.lib.php) in index.php
it comes further and produces at least errors and not just
a blank screen.
8. Calling common.lib.php itself works, too. A broken html-
link to config.inc.php appears (at least something and
no blank page).
9. phpinfo.php does not work, too (only after commenting
out common.lib.php)
10. I am using phpmyadmin since 2.2.6
11. Although error_reporting is set to E_ALL in sourcecode,
the screen remains blank.
I will try the next CVS-updated package.
When it does not work, too, I will look further.
But at the moment I don't even have clues what goes wrong.
All other self-written scripts work fine, even in the
phpmyadmin subdir.
Extension is okay and works (.php)
(Initially the bug is not the blank screen - it is the
MaxExactCount-Issue that I was not able to look
after due to this new issue.)
But I will watch the /CVS and try again.
Logged In: YES
user_id=210714
Which browser are you using? Can you try another browser?
I have not seen any reports about a blank screen for this
development version.
Logged In: NO
Hi,
currently another person reported "Blank screen"
in the BUG-Tracker.
I use Win XP Prof. with IE 6.0.28
I disabled Accelerator, mod_gzip, and
phps output-buffer-compression.
But anyway: php 2.5.0 works fine in the
neighbour-directory with exactly the same
config (just absolute URL plus root password
were added).
The blank screen issue is reported a bit more
detailed in my post in this thread with the
numbered statements.
Logged In: NO
Hi,
even the new CVS from:
21-May-2003 06:06
(.php version in .tar.gz)
Gives blank screen.
Logged In: YES
user_id=210714
Ok, Michal has found and fixed the blank screen problem,
please try again with current cvs.
Logged In: NO
Hi,
the current CVS-version works now!
I tried the MaxExactCount issue and it works now, too!!!
Thank you very much!