[Phpmyadmin-devel] improve listing in server_databses.php

[Sebastian Mendel]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Marc Delisle schrieb:

>>>
>>> Using the page selector directly still logs me out!
>>>
>>>>> 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.
>>
>> ok, i disabled table stats by default, how now?
> 
> 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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (MingW32)

iD8DBQFEPopuX/0lClpZDr4RAsUZAJ4n/YTC4aHC9XlXYdP/6S38fXZXgQCaA3CI
dlM3s2MjbKqvNj23jwotAk4=
=5bfK
-----END PGP SIGNATURE-----