[Phpmyadmin-devel] improve listing in server_databses.php
Marc.Delisle at cegepsherbrooke.qc.ca
Thu Apr 13 07:42:08 CEST 2006
Sebastian Mendel a écrit :
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> Sebastian Mendel schrieb:
>> Marc Delisle schrieb:
>>> Sebastian Mendel a écrit :
>>>> can you please test the server_databases.php?
>>> 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
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.3 (MingW32)
> -----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!
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
More information about the Developers