[Phpmyadmin-devel] improve listing in server_databses.php

[Marc Delisle]

Sebastian Mendel a écrit :
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Sebastian Mendel schrieb:
>> 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.
>>>
>>> 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)
> 
> 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

This is not my case for this test (MySQL 5.1.7) server.
> 
> 
> 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&dat=121642
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>