-
Yes that's correct but this only refers to the number of total rows retrievable by the query, not the to the total number of rows in the table, the show table status from ... qry is also issued at the end and as already said if i kill the query, no information is missing on the page and it displays just fine.
I hope this helps to explain things :)
2009-11-07 12:19:13 UTC in phpMyAdmin
-
I am talking about the normal page where the query results are printed (sql.php) the total number of rows is not shown here and i don't know for what this would be necessary :)
2009-11-07 11:37:23 UTC in phpMyAdmin
-
loading time is improved a little but this is still not satisfactory, why is the query issued here in the first place? The info is not used on that page?.
2009-11-06 21:23:45 UTC in phpMyAdmin
-
Unfortunately it does not, the query is still done when issueing a query:
The Query Printout shows:
SET CHARACTER SET 'utf8';
SET collation_connection = 'utf8_general_ci';
SELECT * FROM `table` WHERE 1 LIMIT 0, 100
SHOW TABLE STATUS FROM `db` LIKE 'table%'
Even when just clicking on SQL the qry:
SHOW TABLE STATUS FROM `db` LIKE 'table%'
is issued.
2009-11-06 20:33:38 UTC in phpMyAdmin
-
Hi, with the normal result page i meant that i go to "SQL" and type in a query, and execute it. This takes 5-10 sec even if the raw query time only is 0,1sec
This especiially seems to happen if the executed query performs some left joins with another table but this is only an assumption
is there any way i can turn on some "debug" to see the queries that where executed?.
2009-11-06 11:51:28 UTC in phpMyAdmin
-
We have run some tests with both 5.0.81 and 5.0.87, using the amd64 linux community edition tarballs. We used a database containing two copies of a table sized about 35 million rows, one copy being innodb and the other being myisam, and a handful of small tables. We had mysql build a fresh ibdata* file set prior to the test. In both cases, SHOW TABLE STATUS behaviour was similar, taking 1 to 5...
2009-11-05 14:00:30 UTC in phpMyAdmin
-
I currently have problems with iterm crashing while quickly switching between multiple Tabs in one Window.
This ony seems to happen after the 0.10 upgrade. I was using the dev versions between 0.9.6 and 0.10 this never occured there.
My System Log reports:
iTerm[91176]: Major fail! Bad file descriptor
and all this runs on a MacbookPro with 10.5.6.
2009-11-04 08:30:23 UTC in iTerm.app
-
yes that's true, sorry i forgot to mention it.
2009-10-27 19:59:27 UTC in phpMyAdmin
-
done :) https://sourceforge.net/tracker/?func=detail&aid=2887357&group_id=23067&atid=377408.
2009-10-27 18:32:18 UTC in phpMyAdmin
-
We suffer very bad performance when surfing in a database with phpmyadmin 3.2.2 and a mysql 5.0.51a
We have a very large DB where some tables have > 15 mio rows and the total row count is above 100 Mio. For the database the Query "show table status from .." performs very bad and takes 5-15s. This query does not only seem to be issued on pages where the information is necessary but also on...
2009-10-27 18:30:57 UTC in phpMyAdmin
