13 Apr
2006
13 Apr
'06
9:55 a.m.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
can you please test the server_databases.php?
the list is now limited to $GLOBALS['cfg']['MaxDbList']
and has navigation
the most speed improvement should be for MySQL 5 and natural order
disabled in phpMyAdmin
- --
Sebastian Mendel
www.sebastianmendel.de
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (MingW32)
iD8DBQFEPlfGX/0lClpZDr4RAmXYAKCvrszjtvZKBJlOoeOoo9k7SsnEdwCgt7m1
BvjFUYLQrHTeMFrllKuTSWo=
=1c+i
-----END PGP SIGNATURE-----
13 Apr
13 Apr
10:15 a.m.
Sebastian Mendel a écrit :
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
can you please test the server_databases.php?
Interesting!
MySQL 5.0.18, $cfg['NaturalOrder'] set to false.
The begin, previous, next, end work as expected, except that the page
number does not change as expected when clicking next. On first page,
click next, still on page 1. Click next, still page 1, Click next, now
on page 2. Click next, now on page 3, this is the last page.
Using the page selector, choose page 2 and I'm back to cookie login
page. Maybe $server is missing.
On the "big" server, nothing appears, mysqld is eating 98% of CPU.
the list is now limited to $GLOBALS['cfg']['MaxDbList']
and has navigation
the most speed improvement should be for MySQL 5 and natural order
disabled in phpMyAdmin
- --
Sebastian Mendel
www.sebastianmendel.de
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (MingW32)
iD8DBQFEPlfGX/0lClpZDr4RAmXYAKCvrszjtvZKBJlOoeOoo9k7SsnEdwCgt7m1
BvjFUYLQrHTeMFrllKuTSWo=
=1c+i
-----END PGP SIGNATURE-----
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&d…
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
10:24 a.m.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Marc Delisle schrieb:
Sebastian Mendel a écrit :
yes, i saw this just seconds after commit .. ;-)
fixed!
Hi,
can you please test the server_databases.php?
Interesting!
MySQL 5.0.18, $cfg['NaturalOrder'] set to false.
The begin, previous, next, end work as expected, except that the page
number does not change as expected when clicking next. On first page,
click next, still on page 1. Click next, still page 1, Click next, now
on page 2. Click next, now on page 3, this is the last page.
Using the page selector, choose page 2 and I'm back to cookie login
page. Maybe $server is missing. On the "big" server, nothing appears, mysqld
is eating 98% of CPU.
What is "big"?
Nothing appears? White page?
But is it now more worse than before on this Server?
Of course to test this you should call ONLY server_databases.php
(without the frames)
- --
Sebastian Mendel
www.sebastianmendel.de
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (MingW32)
iD8DBQFEPl52X/0lClpZDr4RArbTAJ0fEH2zRJOV2cn2EKTFK32Zooe+kACfS48f
zyxxkGwCy8JXBus9qLhEY00=
=reU0
-----END PGP SIGNATURE-----
10:31 a.m.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Sebastian Mendel schrieb:
Marc Delisle schrieb:
mhm, seems MySQL has more trouble sorting this than php doing natural ...
with $cfg['NaturalOrder'] off
mysql will return only need rows and sorted
so this saves traffic between web and db server
this will improve traffic, expecially if you administer an remote db server
with $cfg['NaturalOrder'] on
php seems to be faster sorting the result
seems to be the best if web and db is on the same server
the question is how this 'scales' with more db's ...
i tested only with 4000 empty db's
- --
Sebastian Mendel
www.sebastianmendel.de
Sebastian Mendel a écrit :
What is "big"?
Nothing appears? White page?
But is it now more worse than before on this Server?
Of course to test this you should call ONLY server_databases.php
(without the frames) Hi,
can you please test the server_databases.php?
Interesting!
MySQL 5.0.18, $cfg['NaturalOrder'] set to false.
On the "big" server, nothing appears, mysqld is eating 98% of CPU. -----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (MingW32)
iD8DBQFEPmA6X/0lClpZDr4RAjv6AJwJ+glTcyUuw0a32AhW1xr3KQl5PgCgjb9p
2Y5w8w4oNwaEE7Jc3yRWJM0=
=dmVX
-----END PGP SIGNATURE-----
10:42 a.m.
Sebastian Mendel a écrit :
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Sebastian Mendel schrieb:
This is not my case for this test (MySQL 5.1.7) server.
Marc Delisle schrieb:
mhm, seems MySQL has more trouble sorting this than php doing natural ...
with $cfg['NaturalOrder'] off
mysql will return only need rows and sorted
so this saves traffic between web and db server
this will improve traffic, expecially if you administer an remote db server
with $cfg['NaturalOrder'] on
php seems to be faster sorting the result
seems to be the best if web and db is on the same server Sebastian Mendel a écrit :
What
is "big"?
Nothing appears? White page?
But is it now more worse than before on this Server?
Of course to test this you should call ONLY server_databases.php
(without the frames) Hi,
can you please test the server_databases.php?
Interesting!
MySQL 5.0.18, $cfg['NaturalOrder'] set to false.
On the "big" server, nothing appears, mysqld is eating 98% of CPU.
the question is how this 'scales' with more db's ...
i tested only with 4000 empty db's
My database names are db1 to db4000, each containing tables t1 to t19.
- --
Sebastian Mendel
www.sebastianmendel.de
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (MingW32)
iD8DBQFEPmA6X/0lClpZDr4RAjv6AJwJ+glTcyUuw0a32AhW1xr3KQl5PgCgjb9p
2Y5w8w4oNwaEE7Jc3yRWJM0=
=dmVX
-----END PGP SIGNATURE-----
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&d…
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
10:36 a.m.
Sebastian Mendel a écrit :
4400 databases.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Marc Delisle schrieb:
On my small server, clicking next now works correctly, except for this:
I click 4 times on next, so I should have 5 pages in the selector but I
have only 4. And on the last page, page number in the selector displays 1.
Using the page selector directly still logs me out!
Sebastian Mendel a écrit :
yes, i saw this just seconds after commit .. ;-)
fixed! Hi,
can you please test the server_databases.php?
Interesting!
MySQL 5.0.18, $cfg['NaturalOrder'] set to false.
The begin, previous, next, end work as expected, except that the page
number does not change as expected when clicking next. On first page,
click next, still on page 1. Click next, still page 1, Click next, now
on page 2. Click next, now on page 3, this is the last page.
Using the page selector, choose page 2 and I'm back to cookie login
page. Maybe $server is missing. On the "big" server, nothing appears,
mysqld is eating 98% of CPU.
What is "big"? Nothing appears? White page?
Browser still active, no white page, still seeing the previous page.
But is it now more worse than before on this Server?
yep.
Of course to test this you should call ONLY server_databases.php
(without the frames)
When calling directly I'm logged out.
10:44 a.m.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Marc Delisle schrieb:
Sebastian Mendel a écrit :
works for me ...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Marc Delisle schrieb:
On my small server, clicking next now works correctly, except for this:
I click 4 times on next, so I should have 5 pages in the selector but I Sebastian Mendel a écrit :
yes, i saw this just seconds after commit .. ;-)
fixed! Hi,
can you please test the server_databases.php?
Interesting!
MySQL 5.0.18, $cfg['NaturalOrder'] set to false.
The begin, previous, next, end work as expected, except that the page
number does not change as expected when clicking next. On first page,
click next, still on page 1. Click next, still page 1, Click next, now
on page 2. Click next, now on page 3, this is the last page.
Using the page selector, choose page 2 and I'm back to cookie login
page. Maybe $server is missing. have only 4. And on the last page, page number in the
selector displays 1.
oh, yes, i have some trouble fully understand the use of
PMA_pageselector() ...
- --
Sebastian Mendel
www.sebastianmendel.de
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (MingW32)
iD8DBQFEPmMzX/0lClpZDr4RAh4CAKCg6lonvYjsigfCdbH3c2No4aFA5wCgnwg6
jTSU88CR1ZU6zjysUijp60c=
=5uno
-----END PGP SIGNATURE-----
11:39 a.m.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Marc Delisle schrieb:
ok, this should fixed now
- --
Sebastian Mendel
www.sebastianmendel.de
Sebastian Mendel a écrit :
4400 databases.
ok, i disabled table stats by default, how now?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Marc Delisle schrieb:
On my small server, clicking next now works correctly, except for this:
I click 4 times on next, so I should have 5 pages in the selector but I
have only 4. And on the last page, page number in the selector displays 1.
Using the page selector directly still logs me out!
Sebastian Mendel a écrit :
yes, i saw this just seconds after commit .. ;-)
fixed! Hi,
can you please test the server_databases.php?
Interesting!
MySQL 5.0.18, $cfg['NaturalOrder'] set to false.
The begin, previous, next, end work as expected, except that the page
number does not change as expected when clicking next. On first page,
click next, still on page 1. Click next, still page 1, Click next, now
on page 2. Click next, now on page 3, this is the last page.
Using the page selector, choose page 2 and I'm back to cookie login
page. Maybe $server is missing. On the "big" server, nothing appears,
mysqld is eating 98% of CPU.
What is "big"? Nothing appears? White page?
Browser still active, no white page, still seeing the previous page.
But is it now more worse than before on this
Server?
yep. Of course to
test this you should call ONLY server_databases.php
(without the frames)
When calling directly I'm logged out. -----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (MingW32)
iD8DBQFEPnAsX/0lClpZDr4RAo+iAJ9FMubmfOLRAWbxKjNmK7sETjL5ZwCgg7v8
0ICbVjOa3hXnzC50JimcXlY=
=tb1q
-----END PGP SIGNATURE-----
1:19 p.m.
Sebastian Mendel a écrit :
It works now on the big server, stats generation was really hitting hard
the server! I believe that on a previous version, stats were disabled by
default, it's better this way.
ok, this should fixed now
Confirmed.
Marc
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Marc Delisle schrieb:
> Sebastian Mendel a écrit :
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> Marc Delisle schrieb:
>>> Sebastian Mendel a écrit :
>>>> Hi,
>>>>
>>>> can you please test the server_databases.php?
>>> Interesting!
>>>
>>> MySQL 5.0.18, $cfg['NaturalOrder'] set to false.
>>>
>>> The begin, previous, next, end work as expected, except that the page
>>> number does not change as expected when clicking next. On first page,
>>> click next, still on page 1. Click next, still page 1, Click next, now
>>> on page 2. Click next, now on page 3, this is the last page.
>>> Using the page selector, choose page 2 and I'm back to cookie login
>>> page. Maybe $server is missing.
>> yes, i saw this just seconds after commit .. ;-)
>> fixed!
> On my small server, clicking next now works correctly, except for this:
> I click 4 times on next, so I should have 5 pages in the selector but I
> have only 4. And on the last page, page number in the selector displays 1.
I fixed a calculation bug by adding brackets. Page number was never
selected in the dropdown except on page 1.
Using the page selector directly still logs me out!
4400 databases.
ok, i disabled table stats by default, how now? On the
"big" server, nothing appears, mysqld is eating 98% of CPU.
What is
"big"? Nothing appears? White page?
Browser still
active, no white page, still seeing the previous page.
But is it now more worse than before on this
Server?
yep. Of course
to test this you should call ONLY server_databases.php
(without the frames)
When calling directly I'm logged out.
1:31 p.m.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Marc Delisle schrieb:
It works now on the big server, stats generation was really hitting hard
the server! I believe that on a previous version, stats were disabled by
default, it's better this way.
but it was a really simple LEFT JOIN ... but MySQL seems not to handle
the information_schema like other tables ... MySQL seems not to store db
and table statistics somewhere, it seems it is collected every time it
is requested - this hits the server hard!
- --
Sebastian Mendel
www.sebastianmendel.de
Using the page selector directly still logs me out!
ok, i disabled table stats by default, how now? > On the "big" server, nothing
appears, mysqld is eating 98% of CPU.
What is "big"?
4400 databases.
Nothing appears? White page?
Browser still
active, no white page, still seeing the previous page.
But is it now more worse than before on this
Server?
yep. -----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (MingW32)
iD8DBQFEPopuX/0lClpZDr4RAsUZAJ4n/YTC4aHC9XlXYdP/6S38fXZXgQCaA3CI
dlM3s2MjbKqvNj23jwotAk4=
=5bfK
-----END PGP SIGNATURE-----
1:31 p.m.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Marc Delisle schrieb:
It works now on the big server, stats generation was really hitting hard
the server! I believe that on a previous version, stats were disabled by
default, it's better this way.
but it was a really simple LEFT JOIN ... but MySQL seems not to handle
the information_schema like other tables ... MySQL seems not to store db
and table statistics somewhere, it seems it is collected every time it
is requested - this hits the server hard!
- --
Sebastian Mendel
www.sebastianmendel.de
Using the page selector directly still logs me out!
ok, i disabled table stats by default, how now? > On the "big" server, nothing
appears, mysqld is eating 98% of CPU.
What is "big"?
4400 databases.
Nothing appears? White page?
Browser still
active, no white page, still seeing the previous page.
But is it now more worse than before on this
Server?
yep. -----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (MingW32)
iD8DBQFEPopuX/0lClpZDr4RAsUZAJ4n/YTC4aHC9XlXYdP/6S38fXZXgQCaA3CI
dlM3s2MjbKqvNj23jwotAk4=
=5bfK
-----END PGP SIGNATURE-----
10:27 a.m.
Marc Delisle a écrit :
Sebastian Mendel a écrit :
and SHOW PROCESSLIST displays this (truncated) statement:
SELECT `information_schema`.`SCHEMATA`.*,
COUNT(`information_schema`.`TABLES`.`T
Marc
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
can you please test the server_databases.php?
Interesting!
MySQL 5.0.18, $cfg['NaturalOrder'] set to false.
The begin, previous, next, end work as expected, except that the page
number does not change as expected when clicking next. On first page,
click next, still on page 1. Click next, still page 1, Click next, now
on page 2. Click next, now on page 3, this is the last page.
Using the page selector, choose page 2 and I'm back to cookie login
page. Maybe $server is missing.
On the "big" server, nothing appears, mysqld is eating 98% of CPU.
10:34 a.m.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Marc Delisle schrieb:
Marc Delisle a écrit :
i ahve no trouble with this statement - on my devel machine with local
web and mysql server - a dedicated db server should be much faster than
my machine ...
what MySQL version is running there?
another thing is i have only db's named 1 ... 4000 ... possible MySQL
makes more trouble with 'normal' db names
- --
Sebastian Mendel
www.sebastianmendel.de
Sebastian Mendel a écrit :
and SHOW PROCESSLIST displays this (truncated) statement:
SELECT `information_schema`.`SCHEMATA`.*,
COUNT(`information_schema`.`TABLES`.`T
Hi,
can you please test the server_databases.php?
Interesting!
MySQL 5.0.18, $cfg['NaturalOrder'] set to false.
The begin, previous, next, end work as expected, except that the page
number does not change as expected when clicking next. On first page,
click next, still on page 1. Click next, still page 1, Click next, now
on page 2. Click next, now on page 3, this is the last page.
Using the page selector, choose page 2 and I'm back to cookie login
page. Maybe $server is missing.
On the "big" server, nothing appears, mysqld is eating 98% of CPU.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (MingW32)
iD8DBQFEPmDRX/0lClpZDr4RAvF1AJ4hWuSOogPtA8LS2DgcDRK7GsouLgCgqRhJ
vPqWuGB/4bw5w17wiDpBPps=
=xijJ
-----END PGP SIGNATURE-----
6735
days inactive
6735
days old
12 comments
2 participants
participants (2)
-
Marc Delisle -
Sebastian Mendel