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&da... _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel